Subtotal of values in cells containing formula

  • Thread starter Thread starter KC
  • Start date Start date
K

KC

Hello!

for eg. I have column A with each cells displayed of a value, by is actually
generated by formula. How can I use SUBTOTAL in this case to obtain the
subtotal of value when I use my filter.

To clarify, my cell does not contain whole values like 2,500. It contains:
(e.g)
=(100*AP2)*'Exchange Rate'!$V2$13

My SUBTOTAL could not work in the above instance.

Thanks to advise!! =)
 
Hi,

use

=SUBTOTAL(9,B4:B6)

change range to fit your needs, the above formula will bring the total
despite you using a filter or not
 
Back
Top