Hi there, please refer the attached for more details example?
Thank you for your help in advance.
ex2.xls
Hi there, please refer the attached for more details example?
Thank you for your help in advance.
ex2.xls
Try it like this:
"<="&A1
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
If you really are using 2003, try this...
=SUMIF(Tenor,"<="&H7,Exposure)-SUM($G$9:G9)
If you are using 2007 or later...
=SUMIFS(Exposure,Tenor,">"&G7,Tenor,"<="&H7)
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
Thank you so much... it's really help. Thanks!
You're welcome. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks