Thread: How to sum EstCost if Job = "100000"?
View Single Post
 
Old 04-11-2022, 04:36 AM
Debaser's Avatar
Debaser Debaser is offline Windows 7 64bit Office 2010 32bit
Competent Performer
  
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default
Quote:
Originally Posted by ArviLaanemets View Post
But "'XXX" will never be equal with "XXX"
Really? Works just fine for me. All the relevant figures are included in the SUMIF results. I get 7.8 for EstHours for 100001 even though one row in the source data is 100001 and the other is '100001

Are you saying it doesn't work for you?
Reply With Quote