Hi,

Ronaldo's formula should get you the desired result. One possible reason
for it not working would be that the .ppl column ad use_mtg column has text
instead of numeric entries. Select the .ppl column, go to Data Text to
columns and click on Finish. Repeat the same for the use_mtg column. Now
the formula should work

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"JTurner" wrote in message
...
Anyone? Please??!! Here is another example from the same survey...

I need to count how many total there are where ".ppl" = 2 and use_mtg = 1.
I
can easily get this via pivot table or filters, but I need it in a text
report using formula. There are sixty million of these types of formulas I
have to make...and they all are basically the same thing. If I could get
ONE
to work, I can do the rest.

date time building room .ppl use_mtg
05/03/10 8:30 AM 3 3013 0
05/03/10 10:00 AM 3 3013 1 0
05/03/10 11:30 AM 3 3013 3 1
05/03/10 1:00 PM 3 3013 0
05/03/10 2:30 PM 3 3013 2 1
05/03/10 4:00 PM 3 3013 2 0
05/03/10 5:00 PM 3 3013 2 0
05/04/10 8:30 AM 3 3013 3 1
05/04/10 10:00 AM 3 3013 3 1
05/04/10 11:30 AM 3 3013 2 1
05/04/10 1:00 PM 3 3013 0 0
05/04/10 2:30 PM 3 3013 2 1
05/04/10 4:00 PM 3 3013 0 0
05/04/10 5:00 PM 3 3013 2 1
05/05/10 8:30 AM 3 3013 3 0
05/05/10 10:00 AM 3 3013 1 0
05/05/10 11:30 AM 3 3013 2 0
05/05/10 1:00 PM 3 3013 0 0
05/05/10 2:30 PM 3 3013 0 0
05/05/10 4:00 PM 3 3013 0 0
05/05/10 5:00 PM 3 3013 0 0
05/06/10 8:30 AM 3 3013 1 0