Checking numbers across various sheets

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Hi
Im trying to chk numbers if they match between sheets. I have 7
sheets in the workbook. Is there a way to put the statement below
from sheet1..sheet7?

This formula would be on sheet8 where the person would enter the
number again to confirm its correct!
=IF(NOT(Sheet1!$A1=Sheet1!$B1),"numbers do not match","")

Thanks
Mike
 
Are your sheet names really Sheet1, Sheet2, Sheet3, etc?

You want to check and see if cell A1 = cell B1 on all 7 sheets?

=SUMPRODUCT(COUNTIF(INDIRECT("Sheet"&ROW(INDIRECT("1:7"))&"!A1:B1"),n))=14

Where n = the number to count, or, use a cell to hold that number and
replace n with that cell reference.

Sheet8 A1 = 10

=SUMPRODUCT(COUNTIF(INDIRECT("Sheet"&ROW(INDIRECT("1:7"))&"!A1:B1"),A1))=14

Biff
 
Back
Top