December 22, 2017
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.
April 21, 2015
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.........
June 25, 2016