Find Matching Values in Row - Then add values

[mattytem]

Hi,

Bit of a complicated one to explain, but I would appreciate any help if possible?

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]22 (Days in Month 1)[/TD]
[TD]23 (Days in Month 2)[/TD]
[/TR]
[TR]
[TD]Sam[/TD]
[TD]5[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]James[/TD]
[TD]12[/TD]
[TD]14[/TD]
[/TR]
[TR]
[TD]Bob[/TD]
[TD]20[/TD]
[TD]17[/TD]
[/TR]
[TR]
[TD]Sam[/TD]
[TD]18[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]Bob[/TD]
[TD]2[/TD]
[TD]14[/TD]
[/TR]
</tbody>[/TABLE]

I need to be able to compare the names in Column A, find all the matches (if any), then add up the values in Column C.

If the total doesn't match the days in month, then either highlight the cell outline blue (for lower) or red for (higher)

So, for example in Month 1 Sam has two entries, totaling the value 23, so the border turns red.

Thanks for the help!

 

[JLGWhiz]

I am having a problem correlating your narrative to the example data layout. The narrative refers to columns A & C with Sam's Total = 23, but the example shows the 23 in column B. Please clarify where the data resides on your worksheet.