Working to pull data in from four sheets to a master rollup sheet and keep getting an error

Heather Turley

#incorrect argument set

=COUNTIFS({XXXX Assigned to}, Primary7, {Status}, <>"Complete") + COUNTIFS({XXX Liquid Assigned to}, Primary7, {Status}, <>"Complete") + COUNTIFS({XXXXX Assigned to}, Primary7, {Status}, <>"Complete") + COUNTIFS({XXXXXX Product Range 2}, Primary7, {Status}, <>"Complete")

I'm using a Smartsheet template and the formula was already in the sheet, I just am adding sheets to it. Any help would be appreciated.

Thanks

Heather

Paul Newcome

Are the ranges in each formula referencing the same sheet as the other ranges in the same formula? Basically... Are these cross sheet ranges

COUNTIFS({XXXX Assigned to}, Primary7, {Status}, <>"Complete")

All on the same sheet as each other? Same for the remaining COUNTIFS?