Autofilter & Sumproduct
 

I am summing the product of data in columns B and C. Rows 1 thru 4 are header
rows. Data starts on row 5 and goes thru row 500. When filtering column A, I
want to sum the products of only the visible data in columns B and C. I
tried the following formula
=SUM(SUBTOTAL(3,OFFSET(B4,ROW(B5:B500)-ROW(B4),1))*B5:B500*C5:C500).
Returned #VALUE! when inputing ctrl-shift-enter. Help will be greatly
appreciated. Thank you.

Autofilter & Sumproduct
 

You need to enter it with ctrl + shift & enter but if you change it to

=SUMPRODUCT(SUBTOTAL(3,OFFSET(B4,ROW(B5:B500)-ROW(B4),1)),B5:B500,C5:C500)


it can be entered normally


--


Regards,


Peo Sjoblom


"jwwj232" wrote in message
...
I am summing the product of data in columns B and C. Rows 1 thru 4 are
header
rows. Data starts on row 5 and goes thru row 500. When filtering column
A, I
want to sum the products of only the visible data in columns B and C. I
tried the following formula
=SUM(SUBTOTAL(3,OFFSET(B4,ROW(B5:B500)-ROW(B4),1))*B5:B500*C5:C500).
Returned #VALUE! when inputing ctrl-shift-enter. Help will be greatly
appreciated. Thank you.

Autofilter & Sumproduct
 

Thank you very much.

"Peo Sjoblom" wrote:

You need to enter it with ctrl + shift & enter but if you change it to

=SUMPRODUCT(SUBTOTAL(3,OFFSET(B4,ROW(B5:B500)-ROW(B4),1)),B5:B500,C5:C500)


it can be entered normally


--


Regards,


Peo Sjoblom


"jwwj232" wrote in message
...
I am summing the product of data in columns B and C. Rows 1 thru 4 are
header
rows. Data starts on row 5 and goes thru row 500. When filtering column
A, I
want to sum the products of only the visible data in columns B and C. I
tried the following formula
=SUM(SUBTOTAL(3,OFFSET(B4,ROW(B5:B500)-ROW(B4),1))*B5:B500*C5:C500).
Returned #VALUE! when inputing ctrl-shift-enter. Help will be greatly
appreciated. Thank you.