Help with sumproduct

[Jay07]

Hi all,

Need some help with a sumproduct I've been working on...

=SUMPRODUCT(('Y10 Targets v WAG'!K4:K149<>"")*('Y10 Targets
WAG'!F4:F149="A*" OR "A" OR "B" OR "C"))

It's a simple one working on two variables...

Column K must not be blank, and column F must contain any of A*, A, B o
C.

Any help greatly appreciated.

Jaso

 

[Claus Busch]

Hi Jay;

Am Tue, 13 May 2014 11:32:40 +0100 schrieb Jay07:

=SUMPRODUCT(('Y10 Targets v WAG'!K4:K149<>"")*('Y10 Targets v
WAG'!F4:F149="A*" OR "A" OR "B" OR "C"))

try:
=SUMPRODUCT(--('Y10 Targets v WAG'!K4:K149<>"")*((LEFT('Y10 Targets v WAG'!F4:F149,1)="A")+('Y10 Targets v WAG'!F4:F149="B")+('Y10 Targets v WAG'!F4:F149="C")))


Regards
Claus B.

 

[joeu2004]

Need some help with a sumproduct I've been working on...
=SUMPRODUCT(('Y10 Targets v WAG'!K4:K149<>"")
*('Y10 Targets v WAG'!F4:F149="A*" OR "A" OR "B" OR "C"))

Assuming "A*" is literally "A" followed by star (i.e. star is not a
wild-character), try:

=SUMPRODUCT(('Y10 Targets v WAG'!K4:K149<>"")
*('Y10 Targets v WAG'!F4:F149={"A*","A","B","C"}))

Note the curly braces {...} around the list "A*","A","B","C".