1. On sheet Jobcost you had job codes formatted as text, and then entered them as numbers - getting numeric strings. On sheet SumByJob you had job codes formatted as General, and then entered them preceded with apostrophe to prevent them handled as numbers. "SomeText" doesn't equal with "'SomeText"! So I formatted column A of SumByJob as text, and removed apostrophes from there. After that, formulas SUMIF and SUMIFS (I prefer latter as more universal one) will work.
2. A better solution is to create a pivot table instead. No need to enter new jobs manually. Simply set Pivot to be refreshed on open in Pivot Table Properties, and when there is need to refresh Pivot through session, simply right-click on any cell of Pivot table ans select Refresh from drop-down menu,
|