Remember Me?

#1
 h2ocats Posts: n/a
How do I count data in range A:A that is dependent upon criteria .

I would like to count items in range A:A (header Priority with data 1 through
5) that are dependent upon range B:B )header Status with data IN WRK, COMP,
OPN). So how do I count the 1s in A:A that are "COMP" in B:B?
#2
 JE McGimpsey Posts: n/a

One way:

=SUMPRODUCT(--(A1:A1000=1),--(B1:B1000="COMP"))

See http://www.mcgimpsey.com/excel/doubleneg.html for an explanation of
"--".

In article ,
"h2ocats" wrote:

I would like to count items in range A:A (header Priority with data 1 through
5) that are dependent upon range B:B )header Status with data IN WRK, COMP,
OPN). So how do I count the 1s in A:A that are "COMP" in B:B?

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

 Similar Threads Thread Thread Starter Forum Replies Last Post Sam via OfficeKB.com Excel Worksheet Functions 8 February 3rd 05 01:37 AM Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM Ruud Excel Worksheet Functions 0 January 7th 05 12:15 PM Ruud Excel Discussion (Misc queries) 0 January 7th 05 12:07 PM kman24 Excel Worksheet Functions 2 November 17th 04 02:09 PM

All times are GMT +1. The time now is 02:37 AM.