Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sumif on a filtered column
Hiya
=SUMIF(Sheet2!$F$5:$F$3000,Sheet1!C3,Sheet2!$G$5:$ G$3000) Can I please have some help to modify this formula to ignore (not to sum) hidden rows. The formula works fine, except that it continues to sum rows that are hidden by filtering. Thank you. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sumif on a filtered column
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sumif on a filtered column
Thanks Egun,
"egun" wrote: This thread may help: http://www.microsoft.com/office/comm...A-2D82649C63F5 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting SUMIF to work in Excel 2007 filtered tables? | Excel Worksheet Functions | |||
Count the Y's in a filtered column that contains Y and N | Excel Worksheet Functions | |||
Information from one column then filtered(?) from another | Excel Worksheet Functions | |||
SumIF through filtered data | Excel Worksheet Functions | |||
HOW TO GET A DESIRED 'SUMIF' RESULT FROM A FILTERED DATA | Excel Worksheet Functions |