Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
h2ocats
 
Posts: n/a
Default 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   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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?

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
SUMPRODUCT Formula to Count Row of data Below Matched Criteria Sam via OfficeKB.com Excel Worksheet Functions 8 February 3rd 05 01:37 AM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM
How can I check if data in an external data range is changed afte. Ruud Excel Worksheet Functions 0 January 7th 05 12:15 PM
How can I check if data in external data range is changed after re Ruud Excel Discussion (Misc queries) 0 January 7th 05 12:07 PM
Can you average data in 1 column based on a range of values in another? kman24 Excel Worksheet Functions 2 November 17th 04 02:09 PM


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

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

About Us

"It's about Microsoft Excel"