View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Hank01061567 Hank01061567 is offline
external usenet poster
 
Posts: 5
Default Sum with multiple conditions and wildcard

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???