View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kawboy Kawboy is offline
external usenet poster
 
Posts: 8
Default 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.