COUNTIF from multiple sheets

Chitta

Hi,

Can someone help me on my below formula please!

Scenario: I have a UATStartdate in multiple sheets and I want to store "Overlap" in my UATOverlap column if UATStartdate clashes with other sheets. I am using below formula in UATOverlap column but getting "UNPARSEABLE" error! Kindly help

=IF(COUNTIF([UAT Start Date]1:[UAT Start Date]14 + COUNTIF({Sheet1}) + COUNTIF({Sheet2}), [UAT Start Date]@row) > 1 "Overlap")

Appreciate any help!

~Chitta

Chitta

I was able to correct and below is the corrected formula which works for me.

=IF(COUNTIFS([UAT Start Date]1:[UAT Start Date]3, [UAT Start Date]@row) + COUNTIFS({Sheet1}, [UAT Start Date]@row) + COUNTIFS({Sheet2}, [UAT Start Date]@row) > 1, "Overlap")

Bassam Khalil

Hi @Chitta 

Hope you are fine, if it's possible to share me as an admin on a copy of your sheets (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.

Chitta

I was able to correct and below is the corrected formula which works for me.

=IF(COUNTIFS([UAT Start Date]1:[UAT Start Date]3, [UAT Start Date]@row) + COUNTIFS({Sheet1}, [UAT Start Date]@row) + COUNTIFS({Sheet2}, [UAT Start Date]@row) > 1, "Overlap")

Genevieve P.

Hi @Chitta

Thanks for posting your solution! 🙂