Addings cells in a table

im6894

New member
Joined
Mar 21, 2013
Messages
1
Reaction score
0
Points
0
Hi,

Could someone help me please...

How can I get Excel to add up cells and give me total looking at various cells in a table. The addition will be using only two variables. So for example, if the variable is "JD" then lookup all the JDs and add them up.

Any ideas would be much appreciated.
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
You are looking to Count number of "JD" occurrences in a range?

=COUNTIF(your_range,"JD")

where your-range should be replace with your actual lookup range.

If you are looking to sum a separate column based on finding "JD" in another column

=SUMIF(criteria_range,"JD",sum_range)
 
Top