IF, SUMPRODUCT, VLookup-most efficient?

Not sure what function would be best to use for my formula IFs, SUMPRODUCT, VLookup or combination.

Please review the attached file. I'm trying to get a daily average sale based on the monthly number divided by the number of business days for that month.

Thank you.

excellicious

Here is one option, if I understood you question (see encl. file).
I have used a Data validation list for cell B6 to get the drop down box. Under Menu: Data>Validation...
//Ola

Thank you so much. It is what I needed. Could you explain to me what the -RIGHT and the 4 represent?

Thanks again

Thanks for the feedback. Happy it worked.

This is what RIGHT(B6,4) does:
Since your text says: July (22). RIGHT(B6,4) will pick out the first 4 characters from the right: (22). Since within finance (22) is the same as -22, if I take -(22) that is the same as --22 = +22.

As long as the last 4 characters are (nn), the formula will work. But if you want to change things, just make a new post to the forum and someone will help you.

//Ola

Wow...that is sooo cool..Not only did you help me but you also taught me something new today.

Thanks again..double kudos!