Forum Discussion

TRiceGMH's avatar
TRiceGMH
Copper Contributor
May 01, 2025

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 validate that the total number of all products (Sum of Col D) is equal to the Total Product Count (Col C)?

 

excel

1 Reply

Sort By
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    May 02, 2025

    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.

Resources