Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automated multiple text files into multiple sheets in one workbook | Excel Discussion (Misc queries) | |||
How do I use workbook.sheets.count | Excel Discussion (Misc queries) | |||
How can I count number of sheets present in a workbook? | Excel Discussion (Misc queries) | |||
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
Count sheets in workbook | Excel Discussion (Misc queries) |