verify sums that should agree

B

Bucky

I have a cell E5 that is =SUM(E1:E4) as well as =SUM(A5:D5). The
vertical and horizontal sums should agree. If they don't agree, then it
should display an error or shade the cell red.

Does Excel have any built-in features to do this verification?
Currently, I'm just doing it manually with

=IF(SUM(E1:E4) = SUM(A5:D5), SUM(E1:E4), "error")
 
B

Bucky

Don said:
format>conditional format>formula is>your formula>format as desired
Click to expand...

Thanks. I tweaked it a little bit. Here was my final formula:

cell E5 = SUM(E1:E4)
conditional format: cell value is not equal to =SUM(A5:D5), fill red

This is a easier to understand than my original formula:
=IF(SUM(E1:E4) = SUM(A5:D5), SUM(E1:E4), "error")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum - Sum <> Zero ??? How is it? Bug in Excel formula? 7
INCORRECT RESULT FROM NESTED INDEX ? 2
generate automatically sum 6
Formula Help Needed (Sum and If Then) 1
Count...Sum...Faster...improvemens...; Have a good end of YEAR 2
Date Comparison Formula 4
Summing a column with Text & numbers 5
array functions and ISNUMBER() 1

Top