Prev: Help to create a formulae
Next: Selecting rows with the same criteria
From: enna49 on 15 Mar 2010 22:02
Hi

I am using the code below and only want to sum the Values over 0.00, but if
I add >0 to this it does the COUNT. Please can you let me know if there is
a way of doing this. I have searched and cannot find, maybe I am heading in
the wrong direction.

=SUMPRODUCT(--('FULL CURRENT ATB'!$C$2:$C$4030=$B$3)*('FULL CURRENT
ATB'!$O$2:$O$4030))

Thanking you
From: Max on 15 Mar 2010 22:11
Assuming the col O is the sum range which may contain negative values as well
presumably, you could frame it up like this:
=SUMPRODUCT(('FULL CURRENT ATB'!$C$2:$C$4030=$B$3)*('FULL CURRENT
ATB'!$O$2:$O$4030>0),'FULL CURRENT ATB'!$O$2:$O$4030)
Success? hit the YES below
--
Max
Singapore
---
"enna49" wrote:
> I am using the code below and only want to sum the Values over 0.00, but if
> I add >0 to this it does the COUNT. Please can you let me know if there is
> a way of doing this. I have searched and cannot find, maybe I am heading in
> the wrong direction.
>
> =SUMPRODUCT(--('FULL CURRENT ATB'!$C$2:$C$4030=$B$3)*('FULL CURRENT
> ATB'!$O$2:$O$4030))
>
> Thanking you
From: enna49 on 15 Mar 2010 22:51
Thank you - Worked perfectly

"Max" wrote:

> Assuming the col O is the sum range which may contain negative values as well
> presumably, you could frame it up like this:
> =SUMPRODUCT(('FULL CURRENT ATB'!$C$2:$C$4030=$B$3)*('FULL CURRENT
> ATB'!$O$2:$O$4030>0),'FULL CURRENT ATB'!$O$2:$O$4030)
> Success? hit the YES below
> --
> Max
> Singapore
> ---
> "enna49" wrote:
> > I am using the code below and only want to sum the Values over 0.00, but if
> > I add >0 to this it does the COUNT. Please can you let me know if there is
> > a way of doing this. I have searched and cannot find, maybe I am heading in
> > the wrong direction.
> >
> > =SUMPRODUCT(--('FULL CURRENT ATB'!$C$2:$C$4030=$B$3)*('FULL CURRENT
> > ATB'!$O$2:$O$4030))
> >
> > Thanking you
From: Max on 16 Mar 2010 09:07
welcome, good to hear
--
Max
Singapore

"enna49" <enna49(a)discussions.microsoft.com> wrote in message
news:3BCADB90-26F7-4654-90CC-2355A8D4A30B(a)microsoft.com...
> Thank you - Worked perfectly


 | 
Pages: 1
Prev: Help to create a formulae
Next: Selecting rows with the same criteria