|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 16th, 2010, 02:02 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 
|
|
#2
March 16th, 2010, 02:11 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
|
|
#3
March 16th, 2010, 02:51 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
|
|
#4
March 16th, 2010, 01:07 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sumproduct for Values over a certain Value eg 0.00
welcome, good to hear
-- Max Singapore "enna49" wrote in message ... Thank you - Worked perfectly
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
