Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formula that meets two criteria and sums?
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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 "JE McGimpsey" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|