SUMIF (Continued)

  • Thread starter Thread starter Carl
  • Start date Start date
C

Carl

=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))*(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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF Question 1
formula that writes to a *different* cell? 4
Sumproduct help with a difference 3
Weighted average 4
Alpha sorting (with a twist...?) 3
question re: SUMPRODUCT format 3
formula to find the filter criteria 12
CheckBox Q 1

Back
Top