J
Jeremy
I am trying to write a count if formula to count the total in A1:A3 and count
it to what is in B4:7 in D on if the date in B1:B3 falls in the range of the
date given in D2 and on. Examples below
Thank you for the help
A B C
1 NBC 4/20/09 7865.42
2 NBC 3/28/09 1268.42
3 NBC 4/22/09 1000.00
A D E F
1 Week Start Week Start Week Start
2 3/30/09 4/13/09 4/27/09
4 NBC 1268.42 8865.42
it to what is in B4:7 in D on if the date in B1:B3 falls in the range of the
date given in D2 and on. Examples below
Thank you for the help
A B C
1 NBC 4/20/09 7865.42
2 NBC 3/28/09 1268.42
3 NBC 4/22/09 1000.00
A D E F
1 Week Start Week Start Week Start
2 3/30/09 4/13/09 4/27/09
4 NBC 1268.42 8865.42