Thread
:
How to sum EstCost if Job = "100000"?
View Single Post
04-11-2022, 03:54 AM
ArviLaanemets
Windows 8
Office 2016
Expert
Join Date: May 2017
Posts: 873
Quote:
Originally Posted by
Debaser
FWIW, SUMIF/SUMIFS don't care whether the data is numeric text or a real number, so:
=SUMIF(Jobcost!$A:$A,$A2,Jobcost!D
)
copied across and down would do the job.
But "
'
XXX" will never be equal with "XXX"
ArviLaanemets
View Public Profile
Find all posts by ArviLaanemets