Log In
Register
Home
New Member
Dashboards
Power Query
Power Pivot
Power BI
December 22, 2017
Offline
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.
VIP
April 21, 2015
Offline
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
VIP
Trusted Members
June 25, 2016
Offline
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
1 Guest(s)
