Hi All,
In the attached wooksheet, I have a variety of calculations in C6:N10. I wrote these functions before adding a filter. How can I get these functions to reflect only filtered data?
Thank you for any suggestions!
Sick
Hi All,
In the attached wooksheet, I have a variety of calculations in C6:N10. I wrote these functions before adding a filter. How can I get these functions to reflect only filtered data?
Thank you for any suggestions!
Sick
Last edited by sick stigma; 05-13-2012 at 05:46 PM.
See the SUBTOTAL function.
Entia non sunt multiplicanda sine necessitate
thanks! That took care if most of them. How do you nest SUBTOTAL with IF?
i.e. =SUBTOTAL(109,IF(B12:B112,"=GRANITE")*(G12:G112))
Suggestions?
See the attached.
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
Wow! I glad you didn't try to explain it! I'll try to soak it up for next time.
Thanks!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks