HOW TO GET A DESIRED 'SUMIF' RESULT FROM A FILTERED DATA

[Guest]

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

 

[Guest]

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