Hello,
I am not sure what I'm doing wrong with this formula. It may even be that I'm using the wrong formula.
What I need to do is tally up total sales in the "Sales Forecast" worksheet, for each month from the "Sales Assumptions" worksheet.
However when I tried the following formula in the month of January Cell B4 I get a zero:
Can anyone help with a correct formula? Should I be using some type of lookup formula?=SUMIF('Sales Assumptions'!$B$6:$B$31,B1,'Sales Assumptions'!$F$6:$F$31)
I have attached the file for review.
Thanks
Floridagunner
what column is the data in in the "Sales Forecast" worksheet? your first problem is probably that you are not referencing "Sales Forecast" worksheet in your formula.
Last edited by shg; 01-06-2011 at 05:44 PM. Reason: deleted spurious quote
Hello RMB,
I am trying to display in Cell B9 of the "Sales Forecast" worksheet, the total net sales for January from the "Sales Assumptions" worksheet. I want to then be able to copy the correct formula across and down.
Thanks
Last edited by shg; 01-06-2011 at 05:45 PM. Reason: deleted spurious quote
Guys, please don't quote each others' posts. It's just the two of you.
Thanks.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
In column B of "Sales assumptions" you have date values (formatted to display the month name) while in Sales Forecast B1 you only have a text name for the month. Excel won't match these things together.
Cheers,
“To sin by silence when they should protest makes cowards of men.” ~ Abraham Lincoln
Conne does that mean there is no solution to this?
Last edited by shg; 01-06-2011 at 05:49 PM. Reason: deleted spurious quote
Pilot to Gunner: Please don't quote whole posts. Use the REPLY button.
Over and out.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
On Forecast:
In B1: 1/1/2011
In C1: 2/1/2011
Drag across to M1.
On Assumptions, in B6 and copy down: =C6-DAY(C6)+1
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
The solution will depend on how you need to structure your data, so it's up to you. Do you need column B to contain the date or would the month number suffice?
“To sin by silence when they should protest makes cowards of men.” ~ Abraham Lincoln
Hello,
SHG: I am trying out your suggestion right now.
Conne: Yes Column B in the assumptions tab does need to have the date.
Thanks
Hello SHG,
Your suggestion worked!!!
Thank You!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks