adding only filtered values

  • Thread starter Thread starter salihyil
  • Start date Start date
S

salihyil

hi guys

i have used autofilter function for list of data. what i need is i need
function that will add up only the filtered values. and when the filter
option changed to other learner it needs to add up the new filtered
value automatically

i will be glad if you can solve this
 
Salihil,

Look at the function subtotal(). It is meant to calculate the sum (or
average or ...) of the visible cells of a filtered area.


--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
to save from reading Help, here's the formula. For example, you are subtotalling cells A1:A10. The subtotal formula will be =subtotal(9,A1:A10), then just hit enter. When nothing is filtered, this should equal the sum of A1:A10. If it is filtered, the amount will change to the sum of only the filtered items.
 
Back
Top