|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 3rd, 2003, 02:28 AM
|
|||
|
|||
Functions applied to filtered cells
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. xadamz23 wrote: 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. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html 
|
|
#2
October 3rd, 2003, 01:56 PM
|
|||
|
|||
|
Functions applied to filtered cells
Debra probably meant =SUBTOTAL instead of =sumproduct
"Debra Dalgleish" wrote in message ... 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. xadamz23 wrote: 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. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html
|
|
#3
October 3rd, 2003, 03:00 PM
|
|||
|
|||
|
Functions applied to filtered cells
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!! ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/
|
|
#4
October 3rd, 2003, 07:14 PM
|
|||
|
|||
|
Functions applied to filtered cells
Oops! Thanks Don.
For example, =SUBTOTAL(9,A2:A50) will sum the visible cells. Don Guillett wrote: Debra probably meant =SUBTOTAL instead of =sumproduct "Debra Dalgleish" wrote in message ... 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. xadamz23 wrote: 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. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
