Confused: SUMIF combined with SUBTOTAL?

[kingofcamden]

Dear all,


I am trying to combine SUMIF & AVERAGE with SUBTOTAL to only "SUMIF/AVERAGEIF" visible cells. The formula I use for the SUMIF is:

=SUMIF(Report_Details!AA14:AA8013,1,Report_Details!F14:F8013)

And for the AVERAGEIF:

=AVERAGEIF(Report_Details!AA14:AA8013,1,Report_Details!H14:H8013)

However, as soon as I apply a filter to the data stored in the Report_Details sheet, the formulas don't update to only calculate the visible cells.


Does anyone know how this can be solved? Quite complex and I've tried for a while now with now success


Hope someone can help.


Many thanks,
Mat

 

[Aladin Akyurek]

Is this bit SUM(100/G14*M14)/100 which must not exceed 99%?

 

[kingofcamden]

I had to exclude this from the report for now, so should be fine...
Thanks very much for your help though! Really appreciate it.
Have a good one,
Mat

 

[Aladin Akyurek]

I had to exclude this from the report for now, so should be fine...
Thanks very much for your help though! Really appreciate it.
Have a good one,
Mat

Thanks for the update. By the way, there is no need for SUM around the arithmetic, i.e.,

(100/G14*M14)/100

should be ok.