find all cells in worksheet greater than

Hi anyone can help with this, I'm a bit of a dummy.

i need to find all the rows in a worksheet which have a cell in the row that contains a figure of more than 100,000
90,000
80,000 etc

can i put them in a pivot table and how?

any help with this would be greatful as there are 57 sheets in the workbook
:-(

not looking forward to going through them all just to count

Assuming that you want to count the number of cells in Column C that are greater than 100,000, for all worksheets, try the following...

=SUMPRODUCT(COUNTIF(INDIRECT("'"&A1:A57&"'!C1:C100"),">100000"))

...where A1:A57 contain your sheet names.

Hope this helps!

Originally Posted by hoganc

Hi anyone can help with this, I'm a bit of a dummy.

i need to find all the rows in a worksheet which have a cell in the row that contains a figure of more than 100,000
90,000
80,000 etc

can i put them in a pivot table and how?

any help with this would be greatful as there are 57 sheets in the workbook
:-(

not looking forward to going through them all just to count