Forum Discussion
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: =...
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"))