View Single Post
 
Old 04-07-2022, 11:12 PM
ArviLaanemets ArviLaanemets is online now Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

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,
Attached Files
File Type: xlsx EstActSS.xlsx (20.0 KB, 7 views)
Reply With Quote