Need If and Count

**Sri.n** · 06-28-2013, 07:38 AM

Can any one help me in getting the count of stores with the specified number under which they fall into.

Attached an example for ref

Thanks a lot

**Fotis1991** · 06-28-2013, 07:43 AM

For the first one(same for the last)

=COUNTIF(B2:B16,"<=3000")

For the others..

=SUMPRODUCT(($B$2:$B$16>=3001)*($B$2:$B$16<=20000))

....

**Sri.n** · 06-28-2013, 08:32 AM

Thanks a lot Fotis1991.. Can I have the sum based on the count as well?

**Fotis1991** · 06-28-2013, 08:34 AM

Can you explain a little more..?

**Sri.n** · 06-28-2013, 08:37 AM

Please see the attached file you may get clear idea what I am looking at.

**Fotis1991** · 06-28-2013, 08:42 AM

=sumif(b2:b16,"<=3000")

=sumproduct(($b$2:$b$16>=3001)*($b$2:$b$16<=20000)*($b$2:$b$16))

Re: Need If and Count