Excel IOS SUMIF date criteria

Copper 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

@Britas 

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

@Sergei Baklan 

 

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

@Britas 

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

image.png