Hello everyone, I am trying to create a formula to look at my list of expenses and sum the totals of certain things like groceries, if there is no value I want it to come back as a 0. For the life of me I cannot get it to work. Any suggestions?
=IFERROR(VLOOKUP(A2,D:E,2,FALSE),0)
this is the formula I am currently using but it is only bringing back the first item cost on the list.
here is the example:
Capture.PNG
any help is appreciated. Thanks
Bookmarks