Functions applied to filtered cells

[xadamz23]

Hello,

I want to know if there is a way to apply formulas to filtered cells.
Like addition for example.

I've included a screen print they may help you understand my question
better.

Thanks

File Attached: http://www.exceltip.com/forum/attachment.php?postid=291681 (screen_print2.jpg)

 

[Debra Dalgleish]

I don't see your screen shot, but you can use the SUMPRODUCT function to
calculate visible cells after a filter has been applied. For example,
=SUMPRODUCT(9,A2:A50) will sum the visible cells.

Check Excel's online help for other function numbers that you can use
instead of 9.

 

[Don Guillett]

Debra probably meant =SUBTOTAL instead of =sumproduct

 

[xadamz23]

Debra,

What does the number 9 in your formula reference? Also, say I had
numbers in cells D2 through D200. I apply a filter so only some of
those cells are visible. would i use a formula like
=SUMPRODUCT(9,D2200) to sum only the visible cells?
(or =SUBTOTAL as Don points out)

Thanks again for all of your help

 

[xadamz23]

Nevermind guys. I used Excel's help and figured it out. Thanks Debra
and Don. The =SUBTOTAL(9,A2:A25) formula works just like I want it
to.

Thanks again!!

 

[Debra Dalgleish]

Oops! Thanks Don.

For example, =SUBTOTAL(9,A2:A50) will sum the visible cells.