SUMIFS using DD:MM:YY HH:MM

[jack109]

Hi

Is there a way that you can use SUMIFS when the date is formatted DD:MM:YY HH:MM without a helper column? I can get it to work if I pull date from a cell by using =INT.

Or would another formula be more suited>

Thanks

 

[Cubist]

Something like:

=SUM(IF(criteria_range=criteria,INT(sum_range),0))

 

[jack109]

Thanks didn't orginally work but the INT was in the wrong place, thanks for pointing me in the right direction

=SUM(IF(INT(criteria_range)=criteria,(sum_range),0))

 

[Cubist]

You're welcome.