Hi,
I'm trying to create a countif formula that takes into account 3 different criteria:
countif
a) column R equals "delivery" and
b) column S begins with 2 or begins with 8
So far I've come up with this "if" formula, but excel doesn't seem to like the "or" in it:
IF(OR('Adjustments Dec 2011'!S:S="2*",'Adjustments Dec 2011'!S:S="8*"),COUNTIF('Adjustments Dec 2011'!R:R,'Adjustments Dec 2011'!R:R="DELIVERY"))
I hope this makes sense.
Any help is highly appreciated!
I'm trying to create a countif formula that takes into account 3 different criteria:
countif
a) column R equals "delivery" and
b) column S begins with 2 or begins with 8
So far I've come up with this "if" formula, but excel doesn't seem to like the "or" in it:
IF(OR('Adjustments Dec 2011'!S:S="2*",'Adjustments Dec 2011'!S:S="8*"),COUNTIF('Adjustments Dec 2011'!R:R,'Adjustments Dec 2011'!R:R="DELIVERY"))
I hope this makes sense.
