Assuming your range is A1:B10 =COUNTIF(A1:B10, "YES"
G Gord Dibben Jul 7, 2006 #2 =COUNTIF(A1:G23,"Yes") Gord Dibben MS Excel MVP On Fri, 7 Jul 2006 11:19:01 -0700, Meri <[email protected]> wrote:
=COUNTIF(A1:G23,"Yes") Gord Dibben MS Excel MVP On Fri, 7 Jul 2006 11:19:01 -0700, Meri <[email protected]> wrote: