Counting Data in Cells

  • Thread starter Thread starter Glenn
  • Start date Start date
G

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.
 
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.
 
=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))
 
Back
Top