# COUNTIF from multiple sheets

Options
✭✭✭✭
edited 04/27/21

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

• ✭✭✭✭
Options

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")

• ✭✭✭✭✭✭
Options

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.

bassam.khalil2009@gmail.com

☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

• ✭✭✭✭
Options

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")