Indirect Countifs formula Assistance

[ScottDAndersen]

I am stumped! I want to thank you in advance for any help you can provide. Document example is attached.

I highlighted in yellow where I am trying to write a formula. I want the formula to search the columns and find the column with the associted name then count the number of cells with Xs and the number of cells without Xs.

Is there a formula that would do this?! Im stumped. I have tried multiple countifs without luck.

[kersplash]

In G2;

Please Login or Register  to view this content.

In H2;

Please Login or Register  to view this content.

[protonLeah]

title updated....

[ScottDAndersen]

Thanks so much - your formula worked PERFECTLY when I used it in your spreadsheet, however, when I tried moving it over to my current spreadsheet I am struggling. I pasted my actual spreadsheet so you can take a look at what I am doing.

The cell in yellow is the current formula I need to add that condition/logic to the current countifs formula. In orange is where I have the name that will be changing. On the NYT cancellations tab is where I have the names and x's. For this formula I want to only count the number of cells without X's.

[AliGW]

Thanks for changing the thread title.

[ScottDAndersen]

In G2;

Please Login or Register  to view this content.

In H2;

Please Login or Register  to view this content.

Bumping this to the top. Kersplash, do you think why it wouldn't work with this sheet?

[ScottDAndersen]

After playing around with this formula it looks like the issue is with the row reference because the data I am referencing is on another tab. Is there a way to make this row 8 and 16 reference to a different tab?

[Jonmo1]

Try

=COUNTIF(INDEX('NYT Cancellations'!$F$4:$U$1464,0,MATCH($E$6,'NYT Cancellations'!$F$1:$U$1,0)),"x")

[ScottDAndersen]

Try

=COUNTIF(INDEX('NYT Cancellations'!$F$4:$U$1464,0,MATCH($E$6,'NYT Cancellations'!$F$1:$U$1,0)),"x")

This worked perfectly on its own, however when i try to combine it with my current formula (below) I am getting the #VALUE! error. The formula I am trying to add this new logic to is below.

=COUNTIFS('NYT Cancellations'!$D:$D,Invoices!$C$12,'NYT Cancellations'!$A:$A,">="&$O$8,'NYT Cancellations'!$A:$A,"<="&$P$8)

[ScottDAndersen]

I got it - thank you soo much! I changed my entire column references to start and end with 4 and 1464. You are awesome!