Dear sir,with best regards,asking you kindly to help me by modify the formula mentioned in attached file (column K) to find the monthly sales ( without any change in deatails).
Thanks in advance.
Dear sir,with best regards,asking you kindly to help me by modify the formula mentioned in attached file (column K) to find the monthly sales ( without any change in deatails).
Thanks in advance.
Please change title to describe problem!
Suggest "formula to summarize sales"
=SUMPRODUCT((MONTH($B$6:$B$23)=J8)*(0&$H$6:$H$23))
copied down should work!
Regards
Darren
Update 12-Nov-2010 Still job hunting!
If you are happy with the results, please add to our reputation by clicking the blue scales icon in the blue bar of the post.
Learn something new each day, Embrace change do not fear it, evolve and do not become extinct!
Thank you my dear for help, it works very well.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks