View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ABDUL RAHMAN ABDUL RAHMAN is offline
external usenet poster
 
Posts: 1
Default HOW TO GET A DESIRED 'SUMIF' RESULT FROM A FILTERED DATA

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