![]() |
COLUMN & ROW EQUAL
How do I get a row and a column to add up in the same cell, if it's correct
give the answer, if it's wrong give an error message. |
COLUMN & ROW EQUAL
Maybe something like this:
=IF(SUM(A1:F1)=SUM(A2:A25),SUM(A1:F1),"No Match") -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Wendi" wrote in message ... How do I get a row and a column to add up in the same cell, if it's correct give the answer, if it's wrong give an error message. |
All times are GMT +1. The time now is 07:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com