What I'm trying to do is using the sumproduct function have the formula reference a specific # in the cell range.
Here is formula
=SUMPRODUCT(($B$2:$B$2="Y")*($W$2:$W$2=W2)*($M$2:$M$2))
What I want is for for the range to go from the beginning record to the max number of records in the spreadsheet
End result is this, but am wondering if there is a way to reference the max # of rows in the spreadsheet without manually doing so
=SUMPRODUCT(($B$2:$B$402="Y")*($W$2:$W$402=W2)*($M$2:$M$402))
VBA CODE?????
Thanks! Dan
Here is formula
=SUMPRODUCT(($B$2:$B$2="Y")*($W$2:$W$2=W2)*($M$2:$M$2))
What I want is for for the range to go from the beginning record to the max number of records in the spreadsheet
End result is this, but am wondering if there is a way to reference the max # of rows in the spreadsheet without manually doing so
=SUMPRODUCT(($B$2:$B$402="Y")*($W$2:$W$402=W2)*($M$2:$M$402))
VBA CODE?????
Thanks! Dan