C Carl May 26, 2004 #1 =SUMPRODUCT(--(INT(A7:A9)=INT(B2)),B7:B9) Hi. Thank you for the formula ABOVE 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. Click to expand...
=SUMPRODUCT(--(INT(A7:A9)=INT(B2)),B7:B9) Hi. Thank you for the formula ABOVE 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. Click to expand...
B Bob Phillips May 26, 2004 #3 =SUMPRODUCT((INT(A7:A9)=INT(B2))*(c7:C9="Good"),B7:B9) -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
=SUMPRODUCT((INT(A7:A9)=INT(B2))*(c7:C9="Good"),B7:B9) -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
