View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
KC KC is offline
external usenet poster
 
Posts: 107
Default 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!! =)