Row & Column SUM comparison

S

Spazzman

I have a column of data that I AutoSum. I also have a
row of data that I AutoSum. In the past I have had the
totals written to 2 different cells. If there a way to
have them write to the same cell only if the totals are
equal otherwise list an error?
 
F

Frank Kabel

Hi
do sou mean something like
=IF(ABS(SUM(A1:A100)-SUM(B1:B100))<0.00001,SUM(A1:A100),"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

How do I make AutoSum really Sum, not Subtotal 5
Auto sum only adding the last few numbers in the column. 1
Excel autosum problem in Excel 1
autosum refusal to sum highlighted range 4
An odd problem with SUM(A:B) and AutoSum 2
Autosum and formulas that result in text 4
Calc sometimes off by a penny 5
autosum problems 1

Top