In Column A I have a range of dates
In Column B I have irrelevant data
In Column C I have a list of funds
In Cell D1 I would like to return the value of today's funds
Excel Question.JPG
I have hacked a formula from another part of my spreadsheet (See Formula in image) but I know it's not the right way to do it. Is there a simpler way of doing this?
Hopefully my image shows (My first post) and thank you in advance.
(I am using Excel 2003)
Try this...
=sumif(A:A,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
Happy to help, thanks for the feedback
Just checking that I did in fact thank you! I can't see a comment from me saying thanks so If I didn't ... "Thank you". (I haven't been here for quite some time!)
I got a "thank you" in the rep notification
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks