SUMPRODUCT won't work directly using wildcards.

The technique for a "wildcard-type" match is like this:

ISNUMBER(SEARCH("substring",RANGE))

If you would have provided some details we could have come up with the
appropriate formula.

--
Biff
Microsoft Excel MVP


"Hank01061567" wrote in message
...
Hi,

I am struggling with excel 2003 to essentially SUM a column with multiple
conditions and between 2 dates i.e sum revenues by account, by product,
between Dec 2008 and May 2009. I have used SUMPRODUCT with some success
but
for some reason it doesn't appear to pick up the wildcard in my function.

I have also tried to use the Conditional Sum Wizard with some success
however this dosent appear to be a able to accept a wildcard searching for
text in the formula......having altered the formula after using the
wizard...Is there any way i can use teh wizard with a wildcard???

need the SUMIFS function i think???