Sumif on a filtered column

[LaDdIe]

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.

 

[egun]

This thread may help:

http://www.microsoft.com/office/com...63F5&mid=E134A2C3-D8A8-4BD9-B71A-2D82649C63F5

 

[LaDdIe]

Thanks Egun,