Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Count" and "List" functions across sheets
I have 30 to 60 sheets in several workbooks. I need to do some "drill down"
analysis and reporting: I want it to count specific cells in all sheets that meet certain criteria (e.g., b4<k2, count if blank, count if zero, count if J10 displays "overdue", and so on). Then I need it to look across the same sheets and list the numbers in B1 that meet the above criteria. I've tried lost of permutations with Insert Function and Countwhatever, but all these formulae come back as zero or invalid or "#Value!" or Excel says forget it try again. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Functions for "current" & "previous" month to calculate data | Excel Worksheet Functions | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |