Home > Forum Home > Automating Data Analysis Tasks > Formula selecting Share

Formula selecting

Excel Help for Formula Selecting in Automating Data Analysis Tasks


Forum TopicPost Reply Login

Formula Selecting

Rate this:
(3/5 from 1 vote)
Confused 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 on
 
Replies - Displaying 1 to 3 of 3Order Replies By: Most Recent | Chronological | Highest Rated
Happy
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 on
Confused
Rate this:
(3/5 from 1 vote)
Thank you!
 Posted by on
Confused
Rate this:
(3/5 from 1 vote)
If you’re just counting the number of products for 'USA' rather than summing them, you could try the COUNTIF formula. It works great for quick counts based on criteria in a specific column!
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Formula selecting in the