Formula Query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BoRed79 - 29 Oct 2007 10:40 GMT

I am using a formula to count the number of occurances of an entry - in an
ever expanding list of data.

The formula that I am using is as follows:

=COUNTIF(ActualWeight,">=20")-COUNTIF(ActualWeight,">29")

This counts the number of occurances of a weight between 20 and 29 (where
ActualWeight is a named range for the data).

This formula works absolutely fine and is bringing back a count.

I would now like to extend the formula so that it only counts the above if
it meets another criteria (a school name) - which has a named range of
SchoolName.

Does anyone have any suggestions on what I could try - I have attempted a
couple of things and I cannot seem to get it to work.

Thanks in advance for your help.

Reply to this Message

Ron Rosenfeld - 29 Oct 2007 11:41 GMT

>I am using a formula to count the number of occurances of an entry - in an
>ever expanding list of data.
[quoted text clipped - 16 lines]
>
>Thanks in advance for your help.

Something like:

=SUMPRODUCT((ActualWeight>=20)*(ActualWeight<=29)*(SchoolName="Alvirne High"))

--ron

Reply to this Message

Pete_UK - 29 Oct 2007 11:44 GMT

Try this:

=SUMPRODUCT((ActualWeight>=20)*(ActualWeight<=29)*(School=B1))

where School is the named range and B1 contains the name of the
school.

Hope this helps.

Pete

> I am using a formula to count the number of occurances of an entry - in an
> ever expanding list of data.
[quoted text clipped - 16 lines]
>
> Thanks in advance for your help.

Reply to this Message