This is difficult and I'm lost! Here is the data (omitting not needed)

A D E

Control # Date Time

2 questions:

1. What formula would I use if I wanted to find out the number of #'s

ocurring on Monday between 1/1/06 and 3/31/06 (1st quarter of the year).

1.a IS there a way not to count diplicates of the control #

only... it would

be ok to count duplicate dates, just not duplicate of

control #'s -

which could occur unfortunately becuase of the way the

data is used.

2. What formula would I use if I wanted to find out the number of #'s

occurring between 0000 hours and 0400 hours between 1/1/06 and 3/31/06?

2.a SAME as 1.a

I tried using the sumproduct formula and am completely screwing that up...

please help!

## Bookmarks