| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW TO GET A DESIRED 'SUMIF' RESULT FROM A FILTERED DATA
I HAVE TWO SHEETS.FIRST ONE CONTAINS THE DETAILED DATA AND THE OTHER ONE
SUMMARY WITH 'SUMIF' FUNCTION. BUT WITH THE FILTERED 'DETALED DATA' THE SUMMARY RESULT DOES NOT IGNORE THE SUM OF HIDDEN FIELDS. WILL ANY ONE HELP ME TO GET THE DESIRED RESULT? THANKS AND REGARDS ABDUL RAHMAN |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HOW TO GET A DESIRED 'SUMIF' RESULT FROM A FILTERED DATA
Can you show your SUMIF formula and tell us why the rows are hidden? That
will help us to come up with an appropriate formula. Thanks, Barb Reinhardt "ABDUL RAHMAN" wrote: I HAVE TWO SHEETS.FIRST ONE CONTAINS THE DETAILED DATA AND THE OTHER ONE SUMMARY WITH 'SUMIF' FUNCTION. BUT WITH THE FILTERED 'DETALED DATA' THE SUMMARY RESULT DOES NOT IGNORE THE SUM OF HIDDEN FIELDS. WILL ANY ONE HELP ME TO GET THE DESIRED RESULT? THANKS AND REGARDS ABDUL RAHMAN |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro question | Excel Worksheet Functions | |||
| ranking query | Excel Discussion (Misc queries) | |||
| Copying filtered data to another Excel Spreadsheet | Excel Discussion (Misc queries) | |||
| I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
| EXCEL:NUMBER TO GREEK WORDS | Excel Worksheet Functions | |||
Hybrid Mode
