Hi,
I have daily basis monthly sales. Now I want to summarize into monthly gross. Pls look attached file. I am looking for a formula to summarize January daily sales from date 1st to 31 st as of just January and and sum of each day gross.
Pls need help me in summarise above way.
Thanks
GP
Last edited by top1; 01-06-2010 at 02:19 AM.
In H4:
1/1/2010 (formatted as "mmmm")
In I4:
=SUMPRODUCT(--($A$4:$A$400>=$H4), --($A$4:$A$400<DATE(YEAR(H4),MONTH(H4)+1,1)), $E$4:$E$400)
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
I tried your suggested formula, it shows me some kind of error. Pls tell me if it works for you. Thanks for your help again.
Thanks
GP
As shown here:
Hi There,
I have made certain changes and sure you will find them useful.
IMRAN HAMEED
Perth, Australia
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks