Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM and Frequency for Multiple SHeets
Hi....in sheet 1, I have a column that has unique numbers and using the
following formula to lookup the field in sheet 46500! Column H and then count the unique frequencies in sheet 46500! column A. =SUM(1*(FREQUENCY(IF(('46500'!$H$2:$H$43207<"")*( '46500'!$H$2:$H$43207=$A4),'46500'!$A$2:$A$43207), '46500'!$A$2:$A$43207)0)) How do I change that formula so that it also reads additional sheets (46501, 47400, 43100, 43103, 47300) and only counts the unique combination like the formula above does for one sheet? Please Help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FREQUENCY with multiple criteria | Excel Worksheet Functions | |||
can you use multiple bin arrays in a frequency formula? | Excel Worksheet Functions | |||
counting frequency using multiple ranges/criteria | Excel Worksheet Functions | |||
Frequency and If with multiple Columns | Excel Worksheet Functions | |||
FREQUENCY across multiple worksheets | Excel Worksheet Functions |