How to sum EstCost if Job = "100000"?

		Microsoft Office Forums > Microsoft Excel > Excel
How to sum EstCost if Job = "100000"?

FAQ

Thread Tools

Display Modes

04-11-2022, 03:42 AM

Debaser

Windows 7 64bit How to sum EstCost if Job = "100000"?

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.

Tags

sumif

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mailto Hyperlink Formula contains too large of "Body" receiving "#Value" need to find workaround	MCamera	Excel	1	03-02-2022 07:52 PM
Excel 2003: VBA "Function" causes "#VALUE!" errors after running "insert/delete row" custom macro	Matt C	Excel Programming	2	01-08-2022 06:03 AM
Combine "sort within groups" and "identify duplicate/unique values" in two different variables.	civilcervant	Excel	3	06-12-2017 07:27 AM
remove repeated words with " macro " or " wild cards " in texts with parentheses and commas	jocke321	Word VBA	2	12-10-2014 11:27 AM
How to choose a "List" for certain "Heading" from "Modify" tool?	Jamal NUMAN	Word	2	07-03-2011 03:11 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:45 PM.