Excel function counif problem

  • Thread starter Thread starter FerVerX
  • Start date Start date
F

FerVerX

I have table where in cells A there are dates, in B and C have value
"Y" or "N". So I need a function where I can count all "Y" in bot
cells, but I have to count values in range of dates where starting dat
is in G4 but ending in I4, what formula to us
 
try using sumproduct. Range size must be equal
=sumproduct((daterng>=a1)*(daterng<a2)*(countrng="Y"))
 
Sorry. a small correction to my formula.The ranges should be equal to
sumproduct:

=SUMPRODUCT((A1:A100>=G4)*(A1:A100<=I4)*(B1:C100="Y"))

Regards

Govind.
Hi,

Try

=SUMPRODUCT((A1:A100>=G4)*(A1:A100<=I4)*(B1:C7="Y"))

Regards

Govind.
Click to expand...
 
Back
Top