suming date and time to countif value is less than cell

[mamachrissy1028]

i have a spreadsheet where is data imported from an outside program. It breaks the date and time into 2 separate columns. On my summary page i need to test each entry to determine how many entries are older than a set date and time. However, when i try to use countif or sumproduct i am unsuccessful.

Example:
Column C Column D
3/18/15 1:00
3/18/15 2:00
3/19/15 13:10
3/19/15 15:30

Test date/time
3/19/15 8:00

if column c row 1 + column d row 1 is less than test date time count entry and return # of entries older than 3/19/15 8:00. Thank you!

[Moo the Dog]

You could use a helper column (for instance, column E) that combines columns C and D, using this formula:

=C1+D1

Then use this formula to count the number of entries that are prior to your test date/time:

=COUNTIF($E$1:$E$4,"<"&TestDateCell+TestTimeCell)

- Moo

[mamachrissy1028]

i would really like to avoid adding a column as the person/s using the spreadsheet will be copying and pasting data several times a day and are not everyday Excel users. Avoiding this would be more user friendly. I know there has to be a way to accomplish what i am trying to do, however i am not enough of an Excel wizard to know what that is. Also the cell that it is being tested against is already in a mm/dd/yyyy hh:mm format.