Originally Posted by
ChemistB
INPUTS
By INPUTs do you mean Column A date?
By OUTPUTS Quotes, you want the sum of each month and the total to date from May, June, ... ?
Quotes completed from July start date:
Same thing with Sales?
No, by inputs you will type in the month and year you are interested in and then find the following outputs.
For instance I want to find all the received quotes for June 2010 without regard to the day. So, I'll go to column A and use column A as the reference to look up the input month and year values.
I used the following equation, but it doesn't work:
Then from the found range, I want to find the completed quotes using the Quoted Date column (Column E) and separate quotes that were started in previous months and the current month.
Is that possible?
Bookmarks