Greetings all. I am trying to use SUMPRODUCT with a filter, but I can not
find any posts that answer my questions. I have a spreadsheet with around
10,000 rows, with column A being "JobNum", and each Job number accounts for
around 200 of the rows on the spreadsheet. I have the following:
=SUMPRODUCT(($I$13:$I$65000)*($M$13:$M$65000 = "Cable")*($H$13:$H$65000 =
"CC")) in a cell at the top of the sheet, where column "I" is a numerical
footage, column "M" is a material type, and column H is a line item status.
I would like to be able to filter for each job number in column A, and show
the above SUMPRODUCT, but only for the rows displayed in my filter. I tried
adding the SUBTOTAL function to the above as follows, but it is displaying a
value far greater than it should.
=SUMPRODUCT((SUBTOTAL(9,$I$13:$I$65000))*($M$13:$M $65000 =
"Cable")*($H$13:$H$65000 = "CC")). Any ideas?

Greg