COUNTIF and then SUM in Same Function

W

wayne75

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
 
M

mangesh_yadav

=COUNTIF(A1:A10,"a")-1

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

Mangesh
 
Top