Hi,
I have the following working formula:
How/where can I add a condition please?
It doesn't work the way I thought it should (nor if I replace a comma after "States" by asterisk:
I have the following working formula:
Excel Formula:
=SUMPRODUCT((--(IFERROR(MONTH(IWRS001!$Q$2:$Q$1000),0)=9)),--(IFERROR(YEAR(IWRS001!$Q$2:$Q$1000),0)=2020))
Excel Formula:
IF('IWRS001'!D2:D1000,"United States")
It doesn't work the way I thought it should (nor if I replace a comma after "States" by asterisk:
Excel Formula:
=SUMPRODUCT((--('IWRS001'!D2:D1000,"United States"),(IFERROR(MONTH(IWRS001!$Q$2:$Q$1000),0)=9)),--(IFERROR(YEAR(IWRS001!$Q$2:$Q$1000),0)=2020))