Remember Me?

#1
December 13th 04, 11:13 PM
 C Cooper Midland Posts: n/a
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
December 13th 04, 11:22 PM
 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.

#3
December 14th 04, 02:49 PM
 C Cooper Midland Posts: n/a

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.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

All times are GMT +1. The time now is 05:25 AM.