- Joined
- Oct 20, 2010
- Messages
- 1
- Reaction score
- 0
I am attempting to have the calculation =SUMPRODUCT(C4:C17,D4
17)/C19 work with the viewable cells only and a subtoal when using the autofilter feature in Excel. The figure in C19 would be the subtotal of the filtered data and the autofilter would be applied to the information in columns A & B.
Attached example in .doc format to hopefully explain further. I am looking for the above calculation to work in cell D24 and to be applied to the filtered data only when the autofilter feature is applied. It is currently applies to the entire data range when filtered.
Any help is appreciated
17)/C19 work with the viewable cells only and a subtoal when using the autofilter feature in Excel. The figure in C19 would be the subtotal of the filtered data and the autofilter would be applied to the information in columns A & B.Attached example in .doc format to hopefully explain further. I am looking for the above calculation to work in cell D24 and to be applied to the filtered data only when the autofilter feature is applied. It is currently applies to the entire data range when filtered.
Any help is appreciated
Last edited: