If you want to find out the total sales for a particular month, then the SUMPRODUCT function is your answer. You can create a criteria for a specific date range, a particular month or a year.
In the example below I show you how to use the SUMPRODUCT function to sum up the total sales for a particular month.
Too much Thanks, It was very helpfully.
My best Regards
You are more than welcome Abdul!
Kind Regards,
Bryan
Very useful for my job
Hi Jayakumar, let me know what else you need and we’re more than happy to help!
Good
Hi Jayakumar, I’m glad the Sumproduct formuala was useful to you.
I love Excel it make me look smarter than I really am. What a friend.
That’s what I think every day Randy 🙂
Cheers,
John
