Hi friends...
I have dates in column B
I have sum numbers in Column C
I have month end dates in column E
I need a formula in column F with monthly sum total of numbers in column D
Attaching excel sheet for reference...
Thanks & Regards,
Hi friends...
I have dates in column B
I have sum numbers in Column C
I have month end dates in column E
I need a formula in column F with monthly sum total of numbers in column D
Attaching excel sheet for reference...
Thanks & Regards,
Regards,
Navin Agrawal
Please try this file.
Please click 'Add reputation', if my answer helped you.
Try this, copied down...
=SUMIFS($C:$C,$B:$B,">="&H2,$B:$B,"<"&J2)
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
Thanks....
Will check if it works....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks