Rather than look at specific month (one highlighted in black), I want to look at ALL months in the year 2014. How do I modify this formula to do this?Please Login or Register to view this content.
Rather than look at specific month (one highlighted in black), I want to look at ALL months in the year 2014. How do I modify this formula to do this?Please Login or Register to view this content.
There doesn't appear to be anything highlighted in black.
Can you attach a sample so we can see what you're trying to do? Feel free to use line breaks to keep your formulas organized. Makes troubleshooting much easier.
Please Login or Register to view this content.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Advice => use a pivot table for that question instead of the sumproduct formula.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
[deleted due to corruption of the content]
Last edited by joeu2004; 05-19-2014 at 01:27 PM. Reason: cosmetic
[reposted to try to eliminate some corruption of the content]
Try:
Of course, this presumes that you change B3 to a year number (e.g. 2014, not a date like 1/1/2014) instead of a month name (e.g. "January").Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks