Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 144
Default count if multiple sheets in workbook

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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15,768
Default count if multiple sheets in workbook

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...


Hmmm...

I'm not sure how you'd do that.

--
Biff
Microsoft Excel MVP


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



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15,768
Default count if multiple sheets in workbook

also would like this forumla to grow if the cell
range expands by adding a row...

Hmmm...
I'm not sure how you'd do that.


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

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

--
Biff
Microsoft Excel MVP


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


Hmmm...

I'm not sure how you'd do that.

--
Biff
Microsoft Excel MVP


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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automated multiple text files into multiple sheets in one workbook Dr Dan Excel Discussion (Misc queries) 14 November 4th 07 12:32 PM
How do I use workbook.sheets.count dradon Excel Discussion (Misc queries) 2 October 19th 06 10:33 PM
How can I count number of sheets present in a workbook? Imran Excel Discussion (Misc queries) 1 October 6th 06 11:06 AM
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA Amaxwell Excel Worksheet Functions 4 August 17th 06 06:23 AM
Count sheets in workbook SS Excel Discussion (Misc queries) 3 April 21st 05 12:01 PM


All times are GMT +1. The time now is 07:21 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"