Pivot table report help

Originally Posted by tlafferty

Take a look at the SUMPRODUCT function:

=SUMPRODUCT(--($C$2:$C$8=$A12)*($D$2:$D$8=B$11))

See attached workbook.

Hi,

Thank you.

If the list is on-going, in other words, rows will increase on a weekly basis, how should I go about making the change in the formula to accommodate that?

Please see the attached:

I tried to do...

=SUMPRODUCT(--($C$2:$C$110000=$A12)*($D$2:$D$8=B$11))

and I get #N/A errors in column B in the summation table below. So what I mean is....is there a formula that tells it to always look for the next available value? or this is getting into VBA?

Thank you