Column Formula pulling from 2 Columns on 2 Sheets

System

This discussion was created from comments split from: COUNTIFS: Column Formula pulling from 2 Columns on 2 Sheets.

Natalia Nino

Hi Everyone,

I want to create this same logic from an archive sheet that has the same columns as in the second sheet. So, the first criteria does not allow the formula to run. Any Suggestions?? is it because they are the same??

thank you for the help!

Paul Newcome

@Natalia Nino Try changing the opening curly bracket inside of the red box to an opening square bracket.

{ to [

Natalia Nino

Hi Paul

I changed it but still the same Error.

=COUNTIFS({Carrier Project Range 2}, "Complete", {Carrier Project Range 3}, [Category task]@row) + COUNTIFS({Archive-Change Request Range 1}, "Complete", {Carrier Project Range 3}, [Category task]@row)

What else do you think it could be.

Thanks for your help

Genevieve P.

Hi @Natalia Nino

It looks like your second COUNTIFS is referencing two different sheets - an Archive sheet in the {first reference} but a different sheet (the same one from your first COUNTIFS) in the {second reference}, "Range 3".

You'll want to ensure that the same sheet is being referenced within the parentheses of a COUNTIFS(__). Does that make sense?

Try deleting out the {Carrier Project Range 3} reference from your second COUNTIFS and insert a new reference going to the Archive sheet as well.

Cheers,

Genevieve