Sum a range with multiple criterias

[prazad82]

I have a database which has the following columns:
Industry, Date, Time and Codes. From this data, we prepare another report every 24 hours.

I need to sum, for each industry type how many codes have we received within the 24 hours window (26th Jun 2014, 1.00 PM to 27th Jun 1.00 PM).

I have attached a sample file. Thanks in advance.

 

[Bhawani]

PFA... it will meet your requirement.

 =SUMIFS(D:D,B:B,F2,C:C,">"&TIME(1,0,0))+SUMIFS(D:D,B:B,F2+1,C:C,"<"&TIME(1,0,0))

where F2 would be cell with date reference.