Conditional Sum Based On Time

[BiOlivier]

Hello Everyone,

Please, I need help with this SUMIF FUNCTION. I have a spreadsheet with 1000 items sold in column A and the hour of sale in column D. I am asked to find the total number of items sold after 3PM.In column B I have the price of each item and in column C I have the date of sale of the corresponding item.

I used the following formula: = =SUMIF(A:A, ">3PM",D:D)=549.62

I found a result with decimal. However, there is no decimal in the number of items sold. Since column A (1000 items) represents the items sold. from a part has been sold after 3PM.

Help, please

Olivier

[Excel Fox]

Hi Oliver

Welcome to the ExcelFox community.

Would be good to have a sample file attached, so that a solution can be proposed.