Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I thought I had cracked the Sumproduct function but obviously not!
I have three ranges 1 - ("C39:K39,M39:U39") 2 - ("C40:K40,M40:U40") and 3 - ("C33:K33,M33:U33"). I am trying to count the instances where "Arrow" "Miss" and "Left" all occur in the same column - I thought the following would work but it fails =SUMPRODUCT(--($C$39:$K$39="Arrow"),--($C$40:$K$40="Miss"),--($C$33:$K$33="Left"))+SUMPRODUCT(--($M$39:$U$39="Arrow"),--($M$40:$U$40="Miss"),--($M$33:$U$33="Left")) Even tried:- =SUMPRODUCT(--($C$39:$K$39="Arrow")*($C$40:$K$40="Miss")*($C$33: $K$33="Left"))+SUMPRODUCT(--($M$39:$U$39="Arrow")*($M$40:$U$40="Miss")*($M$33: $U$33="Left")) Thanks Sandy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
'of' percentage with calculation (attempt 2) | Excel Discussion (Misc queries) | |||
Silly Problem with Variable (2nd attempt) | Excel Discussion (Misc queries) | |||
First attempt at VBA coding problem | New Users to Excel | |||
2nd attempt ~ complicated formula | Excel Worksheet Functions | |||
Help - first time to attempt link | Links and Linking in Excel |