Hi guys,
I've been racking my brain over this all afternoon. I have a large data set and don't see an alternative to using nested if statements. I figure there must be a way and I'm missing something. My problem is like me wanting to use vlookup with range as my lookup value. Any help is appreciated. I have a more accurate description of what I'm trying to do on the attached spreadsheet.
Thank you!
Jared
Try this, copied down...
=C4*SUMIFS($I$4:$I$79,$G$4:$G$79,"<="&B4,$H$4:$H$79,">="&B4)
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
Since the dates are discrete ranges and are in ascending order...try this regular formula, copied down:
Please Login or Register to view this content.
Is that something you can work with?
Thank you, Ford! It worked!
Jared
Happy to help
Ron's suggestion should work as well, and it is a bit shoreter
If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)
Done! Thanks again
Thanks again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks