Hi all,

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"))

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 or C.

Any help greatly appreciated.

Jason

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.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

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