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" wrote in message news:3BCADB90-26F7-4654-90CC-2355A8D4A30B(a)microsoft.com...> Thank you - Worked perfectly  |  Pages: 1 Prev: Help to create a formulaeNext: Selecting rows with the same criteria