Forum Discussion
Solved
How to get a sum depending on another column
Hello, I need help to figure out how to get a sum from the value in cells in column J, but I only want the sum of the numbers in J to be accounted for if there is an X in the K-column next to it. Th...
=SUMMA.OM(K15:K23,"x",J15:J23)
You have to translate formula into your language. If this doesn't work try:
=SUMMA.OM(K15:K23;"x";J15:J23)
In some languages formulas have to be entered with " ; " in others with " , ".
=SUMIF(K15:K23,"x",J15:J23)
Above formula returns 6569. Is this what you are looking for?