Using COUNTIFS to reference another sheet

JoanH

I am using a count if formular to get a project count by status and incoming year. Not sure what I am doing wrong but here is my formular. Label@row references project status - in this case "Not Started". I get an output of zero but there are 10 projects with this status.

=COUNTIFS({Project plan status}, Label@row, {Projects incoming year}, AND(@cell = "2023"))

DKazatsky

@JoanH

Remove the @cell and this will work:

=COUNTIFS({Project plan status}, Label@row, {Projects incoming year}, "2023")

-Dave

DKazatsky

Hi @JoanH

The syntax of your formula is a bit off, try this (untested):

=COUNTIFS({Project plan status}, Label@row, {Projects incoming year}, @cell=DATE(2023,1,1))

Hope this helps.

Dave

JoanH

Hi @DKazatsky ,

Thank you!

I just realized the cell i am refencing for the year is a text field. So i tried this formular and still getting zero. i was sure it was going to work.

=COUNTIFS({Project plan status}, Label@row, {Projects incoming year}, @cell = "2023")

DKazatsky

@JoanH

Remove the @cell and this will work:

=COUNTIFS({Project plan status}, Label@row, {Projects incoming year}, "2023")

-Dave

JoanH

thanks. that worked for me