Thread
:
How to sum EstCost if Job = "100000"?
View Single Post
04-11-2022, 03:42 AM
Debaser
Windows 7 64bit
Office 2010 32bit
Competent Performer
Join Date: Oct 2015
Location: UK
Posts: 221
FWIW, SUMIF/SUMIFS don't care whether the data is numeric text or a real number, so:
=SUMIF(Jobcost!$A:$A,$A2,Jobcost!D:D)
copied across and down would do the job.
Debaser
View Public Profile
Find all posts by Debaser