Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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??? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Countif with wildcard criteria | Excel Worksheet Functions | |||
Searching Multiple rows using VLOOKUP with wildcard(*,?) lookup va | Excel Worksheet Functions | |||
How do I count two conditions using a wildcard? | Excel Worksheet Functions | |||
How do I use a wildcard or multiple of a cell value in a formula? | Excel Worksheet Functions | |||
How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions |