Excel function counif problem

[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

 

[Don Guillett]

try using sumproduct. Range size must be equal
=sumproduct((daterng>=a1)*(daterng<a2)*(countrng="Y"))

 

[Govind]

Hi,

Try

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

Regards

Govind.

 

[Govind]

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.

 

[Aladin Akyurek]

=SUMPRODUCT(--(Arange>=$G4),--(Arange<=$I4),(Brange="Y")+(Crange="Y"))