Hi, I am having a bit of trouble getting a sumif formula to work and i cant understand why, im not the best with spreadsheets and generally just google problems to find formulas for different things, im wondering if anyone might be able to help me with this as i just cant understand why it keeps returning 0 for me?
I have Column E with a range of dates and column R with amounts, and i want the forumla to add up any amounts in column R that have the same date in column E as what i have in my column Y.
my formula is =SUMIF(E5:E76,"*"&Y5&"*",R5:R76) to my understanding this formula should add up any amounts in column R where the date in column E is the same as what is in cell Y5?
i created a google sheet with it in but as i am new to this forum it wont let me post the link.
Thanks, Tom.
Bookmarks