View Single Post
  #1   Report Post  
marika1981
 
Posts: n/a
Default SUMPRODUCT(-- Query for Tom Oglivy or others......

I'm using the wonderful formula:

=SUMPRODUCT(--(WTCode="Web
Mail"),--(WTMonthRange=C$8),--(WTYearRange=C$7),WTUnits)

to find a sum based on all the rows with "Web Mail" in the first column.
Any idea how to add a wildcard to this syntax so it would pick up any cell in
that column starting with "Web"? (i.e. Web* - so it would also add "Web
Email", "Web User", "Web Enquiry", etc....)

I've been repeating the full formula above for each occurence, but my
formulae are reaching the max length....

THANK YOU, as always!!!!

Marika :)