Hi,
I have a spreadsheet with two columns, one with project ID's and the other with cumulative hours day by day until the project is completed.
I am trying to just isolate the total # hours, i.e. the last day the hours were added up but cannot figure out how to do so.
Any help would be greatly appreciated!
hi nrrrrb, welcome to the forum. so column D is your desired answers? try this in D2 & copy down:
=IF(A2=A3,"",B2)
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Wow, I can't believe how simple the solution was. I was probably overthinking it because to get the data to the point it's at took a lot of work. Maybe also because it's monday morning. Anyway, thank you so much!
Try this formula in D2 copied down the column
=IF(A3<>A2,B2,"")
Audere est facere
How about in C2 copied down...
=IF(A2<>A3,SUMIFS($B$2:$B$57,$A$2:$A$57,A2),"")
Note: Hmmm...must have read it wrong again
HTH
Regards, Jeff
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks