Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
CountIF or SUM
Hi, I have a large excel sheet. I need to count with
criteria. There are over 5000 entries (rows) I would like to count the number of "Y" in the column Shipped IF the Country is USA. I would also like to count the Number of Dates in DATES Confirmed Column if the country is USA. Can any one assist? Thanks Location Country Shipped Date Confirmed One USA Y 04-Dec-04 Two UK N 11-Nov-04 Three Canada Y 09-Sept-04 Four USA N 04-Dec-04 |
#2
|
|||
|
|||
One way:
=SUMPRODUCT(--(C2:C1000="Y"),--(B2:B1000="USA")) For an explanation of the usage of "--", see http://www.mcgimpsey.com/excel/doubleneg.html In article , "Steve Kay" wrote: Hi, I have a large excel sheet. I need to count with criteria. There are over 5000 entries (rows) I would like to count the number of "Y" in the column Shipped IF the Country is USA. I would also like to count the Number of Dates in DATES Confirmed Column if the country is USA. Can any one assist? Thanks Location Country Shipped Date Confirmed One USA Y 04-Dec-04 Two UK N 11-Nov-04 Three Canada Y 09-Sept-04 Four USA N 04-Dec-04 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
countif statement | Excel Worksheet Functions | |||
Countif | Excel Worksheet Functions | |||
Countif - Countif | Excel Worksheet Functions | |||
countif, again | Excel Worksheet Functions | |||
combining countif formulas | Excel Worksheet Functions |