How can I add data to the monthly sales section in the workbook? I can't seem to figure out the code.
mockup.xlsx
How can I add data to the monthly sales section in the workbook? I can't seem to figure out the code.
mockup.xlsx
Hi
Put proper date numbers in H28:J28, i.e. 10/1/2013, 11/1/2013, 12/1/2013 (format them however you like)
H29 copied across and down
Formula:Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
It seems like I am not entering the code correctly/ The results fill as 1/1 instead of actual sales data.
mockup.xlsx
Richard said real dates in h28:j28 ie the first of each month then format those cells as mmmm to show October November December
you seem to have formatted the cells with the formulas as date m/d change the format of those back to currency
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
thank you. How do you mark thread as solved?
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks