Forum Discussion
sydneyjoanx3x
Mar 07, 2025Copper Contributor
Help, COUNTIFS function
Hi all,
Bit of a long one....
I need cell J3, to calculate the value if Column B = "FW1", if Column H = "Amazon", if column p = "Pending or Closed" , and Column W = "1"
so far i have got: =COUNTIFS('FW Reg'!B:B,"FW1",'FW Reg'!H:H,"Amazon",'FW Reg'!P:P,({"pending","closed"}),'FW Reg'!W:W,"1")
But Excel wont accept it... What am i doing wrong?
How about
=SUM(COUNTIFS('FW Reg'!B:B,"FW1",'FW Reg'!H:H,"Amazon",'FW Reg'!P:P,({"pending","closed"}),'FW Reg'!W:W,"1"))