Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Query of External Data | Excel Discussion (Misc queries) | |||
Microsoft Query Help | Excel Worksheet Functions | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Sumproduct function not working | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |