Excel IOS SUMIF date criteria

%3CLINGO-SUB%20id%3D%22lingo-sub-1038930%22%20slang%3D%22en-US%22%3EExcel%20IOS%20SUMIF%20date%20criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1038930%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20seem%20to%20be%20going%20mad%20-%20I%20can%E2%80%99t%20see%20why%20this%20simple%20formula%20isn%E2%80%99t%20working%3F%20Any%20ideas%20-%20I%20checked%20that%20the%20date%20fields%20are%20formatted%20as%20date.%20It%3CSPAN%3E%26nbsp%3Bworks%20if%20I%20don%E2%80%99t%20using%20the%20greater%20than%20comparison%20and%20just%20use%20G5.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EThanks%20in%20advance.%20It%E2%80%99s%20on%20excel%20on%20my%20iPad%20-%20latest%20iOS%20and%20app%20update%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fforums%2Fpostpage%2Fboard-id%2FExcelGeneral%22%20target%3D%22_blank%22%20rel%3D%22noopener%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F159373iAA7176EF04E3A333%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%228C47CC5F-D985-48CE-8407-6238F972DAC1.jpeg%22%20title%3D%228C47CC5F-D985-48CE-8407-6238F972DAC1.jpeg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FA%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1038930%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20mobile%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1038975%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20IOS%20SUMIF%20date%20criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1038975%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F472144%22%20target%3D%22_blank%22%3E%40Britas%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAnd%20if%20in%20any%20empty%20cell%20to%20test%20%3DD8%26gt%3BG5%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1038978%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20IOS%20SUMIF%20date%20criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1038978%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%20for%20replying.%20It%E2%80%99s%20true.%26nbsp%3B%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F159376iAA25B5088A626839%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%229AC188AF-A367-4520-863B-6FF3620A41A1.jpeg%22%20title%3D%229AC188AF-A367-4520-863B-6FF3620A41A1.jpeg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1038991%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20IOS%20SUMIF%20date%20criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1038991%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F472144%22%20target%3D%22_blank%22%3E%40Britas%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESorry%2C%20have%20no%20ideas%20then.%20On%20my%20iPhone%20it%20works%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20904px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F159377i7AF33CFD819A97A4%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi

 

I seem to be going mad - I can’t see why this simple formula isn’t working? Any ideas - I checked that the date fields are formatted as date. It works if I don’t using the greater than comparison and just use G5.

Thanks in advance. It’s on excel on my iPad - latest iOS and app update

8C47CC5F-D985-48CE-8407-6238F972DAC1.jpeg

3 Replies
Highlighted

@Britas 

And if in any empty cell to test =D8>G5 ?

Highlighted

@Sergei Baklan 

 

thanks for replying. It’s true. 
9AC188AF-A367-4520-863B-6FF3620A41A1.jpeg

Highlighted

@Britas 

Sorry, have no ideas then. On my iPhone it works

image.png