Checking numbers across various sheets
 

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

Checking numbers across various sheets
 

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

"Mike" wrote in message
...
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

Checking numbers across various sheets
 

P.S.

TRUE means all the numbers match. FALSE means all the numbers do not match.

Biff

"T. Valko" wrote in message
...
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

"Mike" wrote in message
...
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