+ Reply to Thread
Results 1 to 2 of 2

COUNTIF and then SUM in Same Function

  1. #1
    Registered User
    Join Date
    05-24-2005
    Posts
    4

    COUNTIF and then SUM in Same Function

    Can anybody tell me if I can do a countif and then within the same formula do a basic sum i.e. Subtract 1 from the countif result (All within the same cell).

    Any help greatly appreciated

    Many Thanks

    Wayne

  2. #2
    Forum Contributor
    Join Date
    06-10-2004
    Location
    India
    Posts
    1,066
    =COUNTIF(A1:A10,"a")-1

    counts the occurance of string "a" in the range A1:A10 and then subtracts 1 from it.

    Mangesh

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1