Sumproduct for Values over a certain Value eg 0.00
 

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

Sumproduct for Values over a certain Value eg 0.00
 

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$40300),'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

Sumproduct for Values over a certain Value eg 0.00
 

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$40300),'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

Sumproduct for Values over a certain Value eg 0.00
 

welcome, good to hear
--
Max
Singapore

"enna49" wrote in message
...
Thank you - Worked perfectly