Thread: How to sum EstCost if Job = "100000"?
View Single Post
 
Old 04-11-2022, 06:45 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
That question wasn't actually directed at you.

It won't work in a pivot table because that does differentiate between text and numbers. SUMIF(S) and COUNTIF(S) do not.
Reply With Quote