Forum Discussion

sydneyjoanx3x's avatar
sydneyjoanx3x
Copper Contributor
Mar 07, 2025

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"))

Resources