=SUMPRODUCT(--(B:B=INT(B:B)),A:A)
=SUMPRODUCT(--(B:B=INT(B:B)),--(B:B>0),A:A)
Date & Time (A COL) | Quantity (B COL) |
11/11:00 | 100 |
11/12:00 | 150 |
11/15:00 | 123 |
12/00:00 | 300 |
12/01:01 | 400 |
13/00:00 | 65 |
column B all has date with time
$scratch.xlsm | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | 11/11:00 | 100 | 365 | |||
2 | 11/12:00 | 150 | ||||
3 | 11/15:00 | 123 | ||||
4 | 12/00:00 | 300 | ||||
5 | 12/01:01 | 400 | ||||
6 | 13/00:00 | 65 | ||||
Sheet6 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
D1 | D1 | =SUMPRODUCT(--(A:A=INT(A:A)),--(A:A>0),B:B) |
So what still appears to be the issue?Hi experts, those entries are time and date just formatted to dd/hh:mm format hence 12/00:00hrs
=SUMPRODUCT(--(A2:A7=INT(A2:A7)),B2:B7)