I have a column B that is full of text values. Progressively as events occur I fill in text values in Column A. If Col B matches Col A as results are entered in Col A I want to color code COL C. That is conditional formatting and I figured that out. A correct match is worth a re-assigned value that is listed in Col C.
At bottom of Col C I want to SUM the correct answers. I know you can't SUM on color coding (conditional formatting) at least not easily. But I think I should be able to use SUMIF to look at matches and only SUM value in Col C where there is a correct match between A and B, but I can't figure out syntax of SUMIF command.
THANKS in advance for helping me figure this out.
Hi Brian,
Welcome here at Mynda's Forum!
There might be different ways to solve this.
I tried it with a helper colomn D, where it gives a '1' if A and B matches and a '0' if not.
And then the sumifs work perfect.
That is: if I understood your question well.........
Frans
Hi Bryan
See if this helps.
1) =SUMPRODUCT(--(A1:A7=B1:B7)*C1:C7)
2) Another version with the helper column similar to Frans solution is to use =IF(A1=B1,C1,0) in column D. You can then just SUM column D
Sunny
