Sumproduct - visible cells
One way is to do the multiplication in another column, say column C. So you
get
A B C
1 2 300 600
2 2 200 400 (hidden/filtered)
3 3 100 100
Then, SUM all visible rows in column C by using SUBTOTAL.
=SUBTOTAL(109, C1:C3)
" wrote:
Hi,
I trying to to use sumproduct only on visible cells and having a hard
time. I read through many help sites, but can't seem to get it to
work. Here's what I'm trying to do to a much larger file...
A B
1 2 300
2 2 200 (hidden/filtered)
3 3 100
How do I set up a formula to get 2*300 + 3*100 = 900?
Thanks.
tinman
|