How to sum EstCost if Job = "100000"?

ArviLaanemets · #1 04-11-2022, 03:54 AM

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"

Debaser · #2 04-11-2022, 04:36 AM

Quote:

Originally Posted by ArviLaanemets

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?

croberts · #3 04-11-2022, 06:18 AM

Quote:

Originally Posted by Debaser

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?

Correct, it doesn't work for me on Office 365. In my pivot table the results for 100001 and '100001 produce two different rows. But the results from SUM look fine. (I wanted to learn to do this 2 different ways.) So it looks like a bug in the Pivot Table but not the SUM or SUMIF functions.

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