sumif

[Guest]

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

 

[Biff]

Hi!

Try this:

=SUMPRODUCT(--(ISNUMBER(A1:A10)),--(MONTH(A1:A10)=MONTH
(TODAY())-1),--(C1:C10<>""),--(N1:N10="upgrade"),R1:R10)

Biff

 

[Guest]

didnt work
formula contains an error.
i tried playing around with it, but i couldnt get it to work

 

[Biff]

Hi!

Then post the EXACT formula that you were using that
counted but did not sum.

Biff

 

[Ken Wright]

Paste the formula into the formula bar and then get rid of the linebreaks
else you will get an error and Excel won't let you enter the formula.

When you paste it straight into the formula bar it will probably appear on
three lines. Get rid of the space at the end, and then the one in the
middle such that the formula appears on a single line.