Originally Posted by
hammcfly
Thank you for your reply. The problem is that not all projects are entered daily. Project 1 may have updates 2 or times a month. So the formula needs to search for "PROJ1" for example, then search for the most recent date only for "PROJ1", then return that amount. All of my attempts are either always defaulting to the most recent date, which may not correspond to that Project ID or simply returning a zero.
See in attached (hopefully) I need it to search column A and B, but some projects have varying record dates. Also, I was incorrect about my Excel version, I have 2021, however, I ultimately need this to work in Google Sheets so I am looking for the most simple solution I can.
Thanks again!
Did you attempt to use what I provided?
I opened your document, put Proj1 - Proj4 into J2 through J5
Added my formulas I gave you to get the most recent date BY PROJECT first in column K
=MAX(IF($A:$A=$J2,$B:$B))
Then in column L the Associated Budget for that Proj/Date pairing
=SUMIFS($C:$C,$B:$B,$K2,$A:$A,$J2)
Which will ALWAYS be the accurate one.
Now if you want BUDGET 2 on your sheet to always be a updated "Latest" added budget we can nest the last date into the second formula and make it part of the table.. so in G2
=SUMIFS($C:$C,$B:$B,MAX(IF($A:$A=$A2,$B:$B)),$A:$A,$A2)
Regardless of choice... what I previously provided does pull the LATEST Budget added by project
Bookmarks