Counting Data in Cells

[Glenn]

I am trying to count the number of cells in that particular column is
between two numbers and equal to a number in an another column (same row)

For example, I need to count all the records in Column A that have a value
between 5 & 11 and when Column E is equal to 4.

I have successfuly been able to use the following formula to count the
number of records in a column that equal a set amount and where the number
or data in another column is equal:

=SUMPRODUCT((Staff!$A$1:$A$500=12)*(Staff!$D$1:$D$500=4))

Thanks.

 

[Leo Heuser]

Glenn

Try this:

=SUMPRODUCT((Staff!$A$1:$A$500>=5)*((Staff!$A$1:$A$500<=11)*(Staff!$E$1:$E$5
00=4))

--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only please.

 

[Ken Wright]

=SUMPRODUCT((Staff!$A$1:$A$500>5)*(Staff!$A$1:$A$500<11)*(Staff!$E$1:$E$500=4))

Just add a couple of = signs if A can equal 5 or 11 as well as being between them, eg

=SUMPRODUCT((Staff!$A$1:$A$500>=5)*(Staff!$A$1:$A$500<=11)*(Staff!$E$1:$E$500=4))

 

[Adrian]

try this:=SUMPRODUCT((A1:A17>5)*(A1:A17<11)*(E1:E17=4))

HTH.