Hello,
As seen in the image below, I want to create a formula to calculate the sum of all values of a matching item, Item B (sum is 68).
Excel issue.png
Hello,
As seen in the image below, I want to create a formula to calculate the sum of all values of a matching item, Item B (sum is 68).
Excel issue.png
Last edited by TinyElephants; 08-13-2021 at 03:21 AM. Reason: attached excel file
Look at SUMIF / SUMIFS functions
I'm not good with formulas. Been struggling with this for a while now. Could you possibly share the formula? Anyway, I'm going to try those functions. Thanks.
It seems to work. What if I have a few columns in-between "Column A" and "Value"?
=SUMIF(A2:B12,"Item B",B1:B12)
Just change "Value" range
e.g if "Values" are in Column G
=SUMIF(A2:A12,"Item B",G2:G12)
Well done for attempting this.
Functions like these (COUNTIF/ COUNTIFS) are commonly used so learn how they work.
Last edited by JohnTopley; 08-13-2021 at 03:49 AM.
Thanks. I will try those.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks