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

Hi!

Try this:

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

Biff

-----Original Message-----
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
.

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

"Biff" wrote:

Hi!

Try this:

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

Biff

-----Original Message-----
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
.

Hi!

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

Biff

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

"Biff" wrote:

Hi!

Try this:

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

Biff

-----Original Message-----
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
.


.

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.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"choice" wrote in message
...
didnt work
formula contains an error.
i tried playing around with it, but i couldnt get it to work

"Biff" wrote:

Hi!

Try this:

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

Biff

-----Original Message-----
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
.