formula that meets two criteria and sums?

C

C Cooper Midland

I need a formula that will determine if information in a database meets two
criteria and then total the number of rows that are correct. The column
titles are Event type and New/Repeat. I need to be able to distinguish if an
event is sports, smerf, or group and then new or repeat. Any help would be
appreciated.
 
J

JE McGimpsey

One way:

Array-entered (CTRL-SHIFT-ENTER, or CMD-RETURN):

=SUM((A1:A1000={"sports","smerf","group"})*((B1:B1000="new")+
(B1:B1000="repeat")))
 
C

C Cooper Midland

Thank You! Thank You! Thank You! I have been working on this for over 3 days
and did not do it as an Array. You are a life saver!!!!

C Cooper
 
Top