=SUM(MAXIFS formula works in some cells and not others

		Microsoft Office Forums > Microsoft Excel > Excel
=SUM(MAXIFS formula works in some cells and not others

FAQ

Thread Tools

Display Modes

02-27-2018, 09:53 AM

garymon9AX garymon9AX is offline

Windows 10 =SUM(MAXIFS formula works in some cells and not others

Office 2013

Novice

Join Date: Feb 2018

Posts: 9

=SUM(MAXIFS formula works in some cells and not others

Please help - this is driving me mad. See attached spreadsheet.

Column J in the 'Network Homes' sheet, is trying to return the latest date from Column C on the 'Job Occurrences' sheet, according to certain criteria in the formula.

Can any one tell me why the cells shaded pink in column J produce silly dates when others in the same column work ok?

I am somewhat of a novice, so would appreciate any help given.

Attached Files

Forum DRAFT PPM TEMPLATE.xlsx (260.6 KB, 12 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula result not displaying in cell (but f9 works)	nath1235	Excel	4	10-06-2017 12:42 PM
Help with a formula which no longer works.	Silkwood	Excel	2	03-21-2017 02:25 PM
Syntax error on formula that works in spreadsheet	Mxthomp	Excel Programming	1	11-02-2016 06:49 PM
Formula works in Excel on my computer, but not on my PDA	Frenchy305	Excel	3	12-17-2015 08:33 AM
Formula works on most cells	gbaker	Excel	1	04-26-2014 12:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:44 AM.