Hi, I am stuck here with something or maybe it's just because it's
Monday morning..

I have a source sheet with values in rows and columns and an output
sheet which should sum the values in column F6-F999 if the values meet
the following criteria:

- date in E6-E999 = date in output$G$3
- value in C6-C99 = BR9

This is my formula and it works fine.

=SUMPRODUCT(VISION!$F$6:$F$999*(VISION!$E$6:$E$999 =OUTPUT!G$3)*(VISION!$C$6:$C$999=\"BR9\"))

Now I discovered though that sometimes the values in C6-C99 vary
slighlty, such as:

BR9
BR9A
BR9B
BR9C
etc.

I want SUMPRODUCT to include all variations of BR9.
In a different case when I had to use the VLOOKUP formula, I used the
following syntax:

\"BR9\"&\"*\"

so the formula looks like this:

=SUMPRODUCT(VISION!$F$6:$F$999*(VISION!$E$6:$E$999 =OUTPUT!G$3)*(VISION!$C$6:$C$999=\"BR9\"&\"*\"))

Unfortunately this returns 0 results so I believe SUMPRODUCT doesn't
understand the syntax...

Anybody got a clue?
Thanks for your help,

Titus.


--
titushanke
------------------------------------------------------------------------
titushanke's Profile: http://www.excelforum.com/member.php...o&userid=19997
View this thread: http://www.excelforum.com/showthread...hreadid=519286