Forum Discussion
[solved] Formula Sum of Values under Matched Content/Heading Condition
I'm trying to create a formula that sums the values under one heading if the row the value is in also has a specific content under another heading. For example (see attached .png), a sum of all the v...
That could be like
=SUMIF(Table1[Loop],"US",Table1[Total 2])
!!!
Adjusted.
=SUMIF(Table7[[All],[Loop]],"UB",Table7[[#All],[Total2]]) worked!
Thank-you!
The issue now is the formula's handling of negatives; where the current sum of UB=115, if the UB with the value of 8 becomes -8, the sum becomes 99 instead of 107 (115-8).
Missed that...
1) You don't need [#All] here. That adds to calculations header and total of the column - not necessary.
2) IMHO, the result is correct. If all positive UB:s are 115 in sum, other words =107+8 with changing plus eight on minus eight the sum will be =107-8 or 99