=sumif('Maintenance By Occurrence 2016'!B:B,"Test",'Maintenance By Occurrence 2016'!D:D)
I have a workbook with different sheets and I'm trying to pull data from one sheet to another. I need the formula to look for a specific name in one column and then bring the amount from another column then sum it on the other sheet. I've posted the formula I'm trying to use but it not working. Any help would be greatly appreciated.
Thank you!
Bookmarks