Hi guys I have this formula:
=SUMIF(B1,">=C3:C5000",F3:F5000)
Cell B1 has a date
Every cell in column C has a combination of dates
Every cell in column F has a balance
I want to add those balances only if they are less than or equal to cell B1... w/my formula I get zero.
Last edited by jgomez; 03-25-2011 at 10:04 AM.
Maybe you need?
=SUMIF(C3:C5000,"<="&B1,F3:F5000)
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
1st i got 5.5E+07 so i formatted to number and got 54562072.45.
The formula is summing all the column F entries where column C has a date less than or equal to the date in B1.
Is that what you want?
Why is that result wrong?
oh you know what.... sorry I want to know how many of them their are not the balance. Sorry too early.
Then perhaps:
=COUNTIF(C3:C5000,"<="&B1)
Thanks, that did it.
I have to bump this, NBVC's solution is just great, thanks!
Hi, I'm trying to sum amount if it has been more than 30 days
I want to add all draws that are 30 days older from today's date, in this case draw 1 and 2
Todays Date 7/24/2018
Draw 1 6/1/18 500
Draw 2 6/15/18 500
Draw 3 7/1/18 500
Draw 4 7/15/18 500
I have tried several formulas with no success
=sumif(B3:C6,"&(today()"-30"),C3:C6))") - error
=SUMIFS(C3:C6,B3:B6,"<7/24/18") - result 2000 when it should be 1000
=SUMIF(B3:B6,C3:C6,"<=30"&B2,C3:C6) - error
Can you guys please give a hand here
Thank you!
Hi pelonsonico,
You would be better served if you start a new thread.
Under Rule 2 of the forum, you are advised not to start a new question on another thread.
Regards,
David
pelonsonico welcome to the forum
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks