Thread: =SUM(MAXIFS formula works in some cells and not others
View Single Post
 
Old 02-27-2018, 11:21 AM
NBVC's Avatar
NBVC NBVC is offline Windows 10 Office 2013
The Formula Guy
  
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default
I think you are summing the max date of each of the items that you are searching column I for... Try using Max instead of Sum

=MAX(MAXIFS('Job occurrences'!C:C,'Job occurrences'!B:B,"s"&A42,'Job occurrences'!I:I,{"Visit Completed","No Access","Action/Info/Appt Reqd","Further Appt Reqd","Job Completed","On Site"}))
Reply With Quote