Forum Discussion
Validating Totals in 2 Columns
I have a column with invoice #s (Col A). I have a column with product names (Col B) I have a column with Total Product Count (Col C) I have a colum with a count of each product (Col D) How do I v...
In E2, enter the following formula:
=SUMIFS($D$2:$D$1000, $A$2:$A$1000, $A$2:$A$1000)=$C$2:$C$1000
This formula will return FALSE in rows where the sums don't match.
You can also use this formula in a conditional formatting rule to highlight problem rows.