Sumif on a filtered column

L

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Refer a column in the 'sumif' function 2
Macro to match 2 column values in different sheets 1
Better way to apply a formula 2
Can I send an email too? 3
Querry in relates to the function SUMIF 1
Complex sum function help - possible? 5
Can I have two conditions in a SUMIF? 5
Sum on multiple columns with search criteria 6

Top