Totaling rows & columns in the same cell

  • Thread starter Thread starter bklover100
  • Start date Start date
B

bklover100

I need to ensure the total in specific rows add up to the total of
column - so that the total for both, if equal, appear in the same cell
For example I need the total in cell G19: to add certain rows such as
=Sum(C19,E19,F19),
if equal to the sum of
=sum(G1:G18).
If not equal I need to receive an error message. How do I do this
 
You could try =IF(SUM(C19,E19,F19)=SUM(G1:G18),"True","Error")

You can replace the "True" with SUM(G1:G18) if you want the total t
apper instead.

=IF(SUM(C19,E19,F19)=SUM(G1:G18),SUM(G1:G18),"Error")

Pet
 
You could also add Conditional Formatting to change the background, border
or font in the cell............would make an error easier to
recognize.............

Vaya con Dios,
Chuck, CABGx3
 
Back
Top