formula that meets two criteria and sums?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
One way:

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

=SUM((A1:A1000={"sports","smerf","group"})*((B1:B1000="new")+
(B1:B1000="repeat")))
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula listing words that meet criteria 5
Conditional Sum - variable criteria 5
Deleting rows meeting certain criteria in a particular column 1
Sum a range based on a column 2
how do sum a column only if meets the criterias of 2 columns 3
Summing and multiplying for multiple criteria 1
Multi-demensional frequency distribution 4
Access Dcount (multiple criteria) 3

Back
Top