Thread
:
formula that meets two criteria and sums?
View Single Post
#
2
JE McGimpsey
Posts: n/a
One way:
Array-entered (CTRL-SHIFT-ENTER, or CMD-RETURN):
=SUM((A1:A1000={"sports","smerf","group"})*((B1:B1 000="new")+
(B1:B1000="repeat")))
In article ,
"C Cooper Midland" <C Cooper
wrote:
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.
Reply With Quote