column A non unique dates in ascending order
column C either a value greater then zero or blank
column N either "upgrade" or blank
column R a number

I need to to sum the values in R, if A is last month, C is not "", N equals
"upgrade".
i tried sumproduct, but that just counted the instances, i need the sum.

thanks in advance