ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   COLUMN & ROW EQUAL (https://www.excelbanter.com/excel-worksheet-functions/195898-column-row-equal.html)

Wendi

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.

RagDyeR

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