I am trying to create a formula that sums the Revenue Column (Range Named "Revenue"), only if the Named Ranges Client="CR" AND Campaign="PCR". I have tried:
{=SUM((Client="CR")*(Campaign="PCR")*Revenue)}
I get a #NUM! error
I have tried not using an array and I get a result but it's not even close. It's so far off that I can't even figure out where it's getting that result from.
What am I missing?
{=SUM((Client="CR")*(Campaign="PCR")*Revenue)}
I get a #NUM! error
I have tried not using an array and I get a result but it's not even close. It's so far off that I can't even figure out where it's getting that result from.
What am I missing?