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.
 
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)
 
Back
Top