Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Sum in Array with wild card and between dates
Hi,
I am trying to SUM a column with two criteria between two dates. i.e. SUM "Revenues" by "product" and by "customer" between two dates to create a search function that enables me to search bewteen any two dates to determine revenues by customer for any given period. I ahve had some success with SUMPRODUCT but i am having difficulty in getting excel to recognise the two dates - my current formula is not recognising the start and end dates so if i exclude these from the formula the amount is the same as it is when they are included i.e sum of revenues since inception of the account. I have also tried to use the conditional sum wizard - which does recognise the dates - however, i have not been able to adapt the formula to be able to include a wild card search for the customer.....Does anyone know how to use the wizard to ascertain teh revenues over any given period???? i can send a copy of teh sheet if you need more info??? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Wild card * in Array | Excel Worksheet Functions | |||
If or and conditional formatting using wild card | Excel Discussion (Misc queries) | |||
Wild card * | Excel Worksheet Functions | |||
Using wild card characters in array formulas | Excel Worksheet Functions | |||
Wild Card and Dates | Excel Worksheet Functions |