Hi,
I'm trying to write a formula to count the number of particular stock items available in stores in different states. I've started writing a COUNTIFS formula which using the example below counts the number based on supplier and dept =COUNTIFS(B2:B404,R1,C2:C404,S1,??)
but i'm getting stuck on how to finish the formula because the numbers for each state are in different columns, if that makes sense??!
I'm trying to write a formula to count the number of particular stock items available in stores in different states. I've started writing a COUNTIFS formula which using the example below counts the number based on supplier and dept =COUNTIFS(B2:B404,R1,C2:C404,S1,??)
but i'm getting stuck on how to finish the formula because the numbers for each state are in different columns, if that makes sense??!
Supplier | Department | Brand | Line | NSW | NT | QLD | SA | TAS | VIC | WA |
x | x | x | x | 1 | 1 | 1 | 1 | 1 | 1 | 1 |