Using 3 criteria, not sure of syntax and what I am doing wrong

Kelly Lawler

I am trying to look up the site code, if a space is a lab, and what BU, all 3 a separate columns on the same sheet - the first two are on a summary sheet successfully as

=COUNTIFS({WDC Lab Inventory_WDC Site Code2}, $[WDC Site Code]@row, {WDC Lab Inventory_Lab Space or Office Space}, "lab")

But then when I try to add the third criteria, I am not sure how -

=COUNTIFS({WDC Lab Inventory_WDC Site Code2}, $[WDC Site Code]@row, {WDC Lab Inventory_Lab Space or Office Space}, "lab", [{WDC Lab Inventory_WDC Site Code}, [WDC Site Code]6, {WDC Lab Inventory_Business Unit}, [Content Solutions]$])

Appreciate the help

Paul Newcome

You just need to follow the syntax of your first two ranges/criteria. There is a square opening bracket " [ " that needs removed from the beginning of your third range, you do not have a row reference for your final criteria, and the very last closing square bracket " ] " after your final criteria needs to be removed.

EDIT: Providing corrected formula using Row 6.

=COUNTIFS({WDC Lab Inventory_WDC Site Code2}, $[WDC Site Code]@row, {WDC Lab Inventory_Lab Space or Office Space}, "lab", {WDC Lab Inventory_WDC Site Code}, [WDC Site Code]6, {WDC Lab Inventory_Business Unit}, [Content Solutions]6)

Paul Newcome

@Kelly Lawler I noticed that you "rejected" my answer. Did it not work for you?

Kelly Lawler

thank you - got it working!!!

Paul Newcome

Excellent! Happy to help! 👍️