Help with sumproduct


J

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
 
Ad

Advertisements

C

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.
 
Ad

Advertisements

J

joeu2004

Jay07 said:
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".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top