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
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
=COUNTIF(A1:A10,"a")-1
counts the occurance of string "a" in the range A1:A10 and then subtracts 1 from it.
Mangesh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks