Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Do I need SUMPRODUCT?
The following is a formula I am using that totals a range meeting a
single criteria. =SUMIF(D2:D254,D507,E2:E254) However, I now want to give an additional condition; that is (F2:F254) = "" I think I want SUMPRODUCT but I am not sure how to use it? Can anyone help? My thanks to those who can. Dave Moore |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Do I need SUMPRODUCT?
Got it! =SUMPRODUCT(($D$2:$D502=D507)*($F$2:$F502="")*($E$ 2:$E502)) works for me. Are there any shorter versions? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Do I need SUMPRODUCT?
Hi
Not shorter, but this one may give you some gain in speed, when you have a lot of such formulas =SUMPRODUCT(--($D$2:$D502=D507),--($F$2:$F502=""),($E$2:$E502)) -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "DaveMoore" wrote in message oups.com... Got it! =SUMPRODUCT(($D$2:$D502=D507)*($F$2:$F502="")*($E$ 2:$E502)) works for me. Are there any shorter versions? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Do I need SUMPRODUCT?
SUM(($D$2:$D502=D507)*($F$2:$F502="")*($E$2:$E502) )
Fewer key stroke than sumproduct ctrlshift enter (not just enter) "DaveMoore" wrote: Got it! =SUMPRODUCT(($D$2:$D502=D507)*($F$2:$F502="")*($E$ 2:$E502)) works for me. Are there any shorter versions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct | Excel Worksheet Functions | |||
sumproduct causing memory errors? | Excel Worksheet Functions | |||
Can I reference =, <, or > sign in SUMPRODUCT | Excel Discussion (Misc queries) | |||
Sumproduct function not working | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |