LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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 :)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Query of External Data Excel GuRu Excel Discussion (Misc queries) 2 January 3rd 05 07:43 PM
Microsoft Query Help Patti Excel Worksheet Functions 4 December 25th 04 09:54 AM
How to use a Access Query that as a parameter into Excel database query Karen Middleton Excel Discussion (Misc queries) 1 December 13th 04 07:54 PM
Sumproduct function not working Scott Summerlin Excel Worksheet Functions 12 December 4th 04 05:15 AM
adding two sumproduct formulas together ski2004_2005 Excel Worksheet Functions 1 November 12th 04 09:08 PM


All times are GMT +1. The time now is 07:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"