Hello, I am trying to add all orders that are done on the same month and then divide it the number of days in order to calculate the average demand rate. My problem is that I can not design an if statement or sum, or whatever it should be that reads the date and then if the date is correct it adds the item 1 ordered.
Here is the file.HW2.xlsx
The Month function returns the month number (1 to 12) for a given date.
Entia non sunt multiplicanda sine necessitate
=IF(MONTH(B4:B497)=1,SUM(D4:D497),0) I tried it like this but it doesn't work
Add a helper column for the MONTH() function - say column E, then try the sumif() function. Maybe...
=SUMIF(E4:E497,1,D4:D497)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Sorry, I had not looked at your file, just based my suggestion off what you provided in your formula. In D514, use this, copied down and across...
=SUMPRODUCT((MONTH($B$4:$B$497)=ROW(A1))*(D$4:D$497))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks