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?
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?