I need a formula that will count up how many people meet certain criteria based on specific information in 2 different columns.
Jack
I need a formula that will count up how many people meet certain criteria based on specific information in 2 different columns.
Jack
Try the following...
=SUMPRODUCT(--(Range1=Cond1),--(Range2=Cond2))
Hope this helps!
Originally Posted by hilton
That doesn't seem to work
Maybe I need to give you more information, the report asks for the number of single families at the beginning of the project year.
Col A Col B
Date Single/Family
1/1/05 s
1/10/05 s
1/1/05 F
So the answer should be 1.
Jack
Try the following...
=SUMPRODUCT(--(A1:A3="1/1/05"+0),--(B1:B3="s"))
OR
=SUMPRODUCT(--(A1:A3=C1),--(B1:B3=D1))
...where C1 contains the date of interest and D1 contains the status of interest.
Hope this helps!
Originally Posted by hilton
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks