Hi all,
I have a home expenses spread sheet & I need a code to auto sum what bills still need paying for the remainder of the month, I have attached a simple spread sheet that explains a little further, as always any assistance will be gratefully received, thank you all & have great day - Marco
Try this...
=SUMIF(A:A,">"&DAY(TODAY()),C:C)
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
Maybe this...
=SUMIF(A:A,">"&DAY(E1),C:C)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Thank you guys, they both work perfectly...must admit I do find it a little frustrating at how easy you guys make this look, thank you both & have a great day! - Marco
You just need to have a grasp of some of the standard functions that excel offers. After that, it's just a matter of picking the right tool for the job
You're welcome. We appreciate the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks