|
Excel Spreadsheet:
|
A |
B |
C |
1 |
Country |
Product |
Qty |
2 |
USA |
Lemon |
230 |
3 |
USA |
orange |
450 |
4 |
Thailand |
lemon |
125 |
5 |
France |
grape |
410 |
6 |
USA |
banana
|
220 |
7 |
India |
lemon |
230 |
How can I count the number of all USA products? |
| Posted by Andrew Perkins on | |
| Rate this: ( 4/5 from 2 votes)
Use the SUMIF formula with the criteria range on column A and SUM range on column C with criteria "USA" |
| Excel Business Forums Administrator |
| Posted by Excel Helper on |
| Rate this: ( 3/5 from 1 vote)
Thank you! |
| Posted by Andrew Perkins on |