C
carl
Hi. Thank you for the formula below which enabled me to
Count the number of Cancel Requests based on Matching the
Date in B2 with a Date (in a "custom" format) in A7:A9.
=SUMPRODUCT(--(INT(A7:A9)=INT(B2)))
My next question is if the formula can be modified to do
the same date matching but SUM (vs Count) the values in
B7:B9 ?
A B
2 Monitoring Statisitics 05/24/04
3 # Cancel Requests 3
4 Volume of Cancel Requests ??
A B
6 Cancel Time Units
7 05/24/04 10
8 05/24/04 10
9 05/24/04 20
Count the number of Cancel Requests based on Matching the
Date in B2 with a Date (in a "custom" format) in A7:A9.
=SUMPRODUCT(--(INT(A7:A9)=INT(B2)))
My next question is if the formula can be modified to do
the same date matching but SUM (vs Count) the values in
B7:B9 ?
A B
2 Monitoring Statisitics 05/24/04
3 # Cancel Requests 3
4 Volume of Cancel Requests ??
A B
6 Cancel Time Units
7 05/24/04 10
8 05/24/04 10
9 05/24/04 20