Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 13th 04, 11:13 PM
C Cooper Midland
 
Posts: n/a
Default 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   Report Post  
Old December 13th 04, 11:22 PM
JE McGimpsey
 
Posts: n/a
Default

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   Report Post  
Old December 14th 04, 02:49 PM
C Cooper Midland
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



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

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017