Excel 2003 sum if or count if ... or is it something else ???
Here is what I think I want to do ...
=COUNT(A!F:G,"Telephone")IF(A!K:L,"Other")
or
=SUM(A!F:G,"Telephone")IF(A!K:L,"Other")
but neither of those formula return a value.
I know the correct formula will be easy, maybe even easier than these, but I
don't know what it is.
|