Hi.
I have a workbook for sales information.
'Sheet1'!A3 I want to put a number (2000) to compare
Sheets 2 - 26 G2:G30 is the information I want to look at

Sheets 2-26 F40 Counts the values in G2:G30 that are Greater
Than 'Sheet1'!A3
Sheets 2-26 F41 Counts the values in G2:G30 that are Less
Than 'Sheet1'!A3

Sheets 2-26 G40 Sums the values in G2:G30 that are Greater
Than 'Sheet1'!A3
Sheets 2-26 G41 Sums the values in G2:G30 that are Less Than
'Sheet1'!A3

I can get the answers if I put in the 2000 into each of the following
formulas,
but is very laborsum to do it for 25 worksheets
F40 =COUNTIF(G7:G16,"2000") and G40 =SUMIF(G7:G17,"2000")
F41 =COUNTIF(G7:G16,"<2000") and G41 =SUMIF(G7:G17,"<2000")

All help would be very appreciated
Mike