count if multiple sheets in workbook

  • Thread starter Thread starter kathy
  • Start date Start date
K

kathy

I have thiry pages in workbook for month .. want to put a summary at the end
that counts cells F24 to cells F34 on each of these sheets if the amount is
greater than 500.00 .. also would like this forumla to grow if the cell range
expands by adding a row... countif(F24:F34,">500")... doesn't like to
incorporate more than one page... please advise what would be the best for
this .. at the end of 12 months I want also to total each months summary
total for a yearly total.. would a macro would be better than formulas? help?
please? this is beyond what I can figure out.. thank you
 
One way...

Assuming your sheet names are Sheet1, Sheet2, Sheet3, etc.

=INDEX(FREQUENCY(Sheet1:Sheet30!F24:F34,500),2)
also would like this forumla to grow if the cell
range expands by adding a row...
Click to expand...

Hmmm...

I'm not sure how you'd do that.
 
also would like this forumla to grow if the cell
Hmmm...
I'm not sure how you'd do that.
Click to expand...

Maybe just use a larger range that allows for future expansion:

=INDEX(FREQUENCY(Sheet1:Sheet30!F24:F100,500),2)
 
Back
Top