All I am trying to say is I want the sum of column D if no value in my defined named revenue (KNOWN_REVENUE) matches anything in column C.
This is probably way off.
=SUMIFS(D:D,C:C,<>KNOWN_REVENUE)
Here is an example.
KNOWN_REVENUE
APPLES
PEARS
ORANGES
column C column D
APPLES 20
PEARS 10
GRAPES 30
ORANGES 20
And the formula would produce the value 30, because grapes is not listed in my defined named table.
This is probably way off.
=SUMIFS(D:D,C:C,<>KNOWN_REVENUE)
Here is an example.
KNOWN_REVENUE
APPLES
PEARS
ORANGES
column C column D
APPLES 20
PEARS 10
GRAPES 30
ORANGES 20
And the formula would produce the value 30, because grapes is not listed in my defined named table.
Last edited: