COLUMN & ROW EQUAL

  • Thread starter Thread starter Wendi
  • Start date Start date
W

Wendi

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.
 
Maybe something like this:

=IF(SUM(A1:F1)=SUM(A2:A25),SUM(A1:F1),"No Match")
 
You must log in or register to reply here.

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

Excel Help to copy information from one row at a time to another sheet 1
hidden rows problem 7
sumifs/sumproduct 8
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Hide columns based on row values 2
CountIf with And 0
How to find the first row not equal to the value in the first row? 8
complex sort search and replace macro 2

Back
Top