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.

Sumif on a filtered column
 

This thread may help:

http://www.microsoft.com/office/comm...A-2D82649C63F5

Sumif on a filtered column
 

Thanks Egun,

"egun" wrote:

This thread may help:

http://www.microsoft.com/office/comm...A-2D82649C63F5