Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct Erro
Why am I not getting the right result with the below formula?
Col/row D E F 2 type hole1 hole2 hole3 hole4 3 par 4 4 3 5 4 0 4 5 4 7 =SUMPRODUCT(--($D$3=D4),--($E$3=E4),--($F$3=$F$4)) My aim is to count how many times I par or birdie a hole in a round of golf. This result returns zero not 1. TIA Bec |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct Erro
See response in public.excel
-- HTH Bob "AussieBec" wrote in message ... Why am I not getting the right result with the below formula? Col/row D E F 2 type hole1 hole2 hole3 hole4 3 par 4 4 3 5 4 0 4 5 4 7 =SUMPRODUCT(--($D$3=D4),--($E$3=E4),--($F$3=$F$4)) My aim is to count how many times I par or birdie a hole in a round of golf. This result returns zero not 1. TIA Bec |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct Erro
In your formula E3<E4 and F3<F4 so you are multiplying 1 by 0 by 0, so the
answer is 0. Perhaps you intended =SUMPRODUCT(--(D3:F3=D4:F4)) ? But note also that you are counting pars, not birdies. If you want to count birdies, try =SUMPRODUCT(--(D3:F3=D4:F4+1)) -- David Biddulph "AussieBec" wrote in message ... Why am I not getting the right result with the below formula? Col/row D E F 2 type hole1 hole2 hole3 hole4 3 par 4 4 3 5 4 0 4 5 4 7 =SUMPRODUCT(--($D$3=D4),--($E$3=E4),--($F$3=$F$4)) My aim is to count how many times I par or birdie a hole in a round of golf. This result returns zero not 1. TIA Bec |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Erro Msg: Cannot Empty The Clipboard | Excel Discussion (Misc queries) | |||
Visual Basic Erro 400 | Excel Worksheet Functions | |||
Macro erro | Excel Discussion (Misc queries) | |||
Excel Erro | Setting up and Configuration of Excel | |||
Erro in Formula, Pleas Help? | Excel Worksheet Functions |