Countifs Formula that counts if 1 of 2 columns has a Y in it

[hofst038]

Need a little help. I need help with my formula that needs to count every instance, during a specific time period, when either 1 of 2 columns has a text (in this case a Y) in it.

Heres what I have so far:

=COUNTIFS(Date,">"&'Weekly Report'!F2,Date,"<"&'Weekly Report'!G2,'Checkout List'!$AF:$AF,"Y")+COUNTIFS(Date,">"&'Weekly Report'!F2,Date,"<"&'Weekly Report'!G2,'Checkout List'!$AG:$AG,"Y")

This is doing its job and counting the Y's; however, if both columns have a Y in them it is counting both and returning 2 because it is counting both Y's in each column. What I want is for it to return a count of 1, not 2. Does this make sense?

 

[Tetra201]

Try:

=SIGN(COUNTIFS(...)+COUNTIFS(...))

 

[hofst038]

Nailed it. Worked perfectly, thanks!

 

[Tetra201]

You are welcome.