Forum Discussion
formula
hi I need a formula please. I need to find the sum of all compensation for each the of first column...like add all of compensation for 4 regardless of letter, so compensation is 406000. I tried to p...
The formula in G2 (and copied down) is:
=SUMIFS($C$2:$C$18, $A$2:$A$18, E2 & "*", $B$2:$B$18, F2)
thank you, this helps me tremendously!