SUMPRODUCT Using Unary on Filtered Range

  • Thread starter Thread starter ExcelMonkey
  • Start date Start date
E

ExcelMonkey

I have a filtered range which l sum using the SUBTOTAL(9, A1:A100
formula. It allows me to sum the filtered range without bringing i
the data that is not included in the filtered range. I want to do
SUMPRODUCT on this filtered range. Normally I would use the followin
SUMPRODUCT(A1:A100, B1:B100). However this will not work on a filtere
range. How can I do this in one formula without creating a ne
column?

Thank
 
Hi
try
SUMPRODUCT(A1:A100,
B1:B100,SUTOTAL(3,OFFSET($A$1,ROW($A$1:$A$100)-1,0)))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMPRODUCT formula is summing text and I want it to stop doing that 2
Excel Countifs/Sumproduct with mutil Or statement 3
Macro that copies values from column A (from formula) to B (paste value) 1
Excel 2013: AutoFilter and SUM() 1
Excel 2013 1
Use of sumproduct() in EXCEL 7
Macro to copy value in field and insert it into filter 2
Sum of products 2

Back
Top