Subtotal of values in cells containing formula
 

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!! =)

Subtotal of values in cells containing formula
 

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

"KC" wrote:

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!! =)