You are not clear with your question and your vba code is also
protected
On May 31, 4:58 am, H Upadhyay wrote:
> Dear All,
>
> pls go through the attached file.
>
> here i m passing row no, is there any way with out passing any row no it
> solve entire for entire column
>
> Regards
> Harish
On Jun 2, 6:39 am, Jay wrote:
> Hi,
>
> You can use sumproduct formula as below :
>
> =SUMPRODUCT(--(A4:A8>=100),--(A4:A8<=300),(B4:B8))
>
> it's give the same result ...
>
> On Jun 1, 7:52 pm, Dilip Pandey wrote:
>
>
>
> > Hi Nidhesh,
>
> > Excellent criteria.
> > I have attached one file whi
Hi Jay,
What does this "--" double dash do in this formula.
Thanks
Exceltech
On Jun 2, 6:39 am, Jay wrote:
> Hi,
>
> You can use sumproduct formula as below :
>
> =SUMPRODUCT(--(A4:A8>=100),--(A4:A8<=300),(B4:B8))
>
> it's give the same result ...
>
> On Jun 1, 7:52 pm, Dilip Pandey wrote:
>
