How to perform a COUNTIF on multiple selections?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DavidJ726 - 27 Nov 2006 01:47 GMT

I'm trying to perform a countif on two different ranges of cells but am
having difficulty figuring out how to get past the first range. This is
what I have that does work...

=COUNTIF(Sheet1!A13:AA39,"*David*")

I've tried nesting the ranges with parantheses a couple of different ways
but it didn't work. What would the proper expression be to add another
range of cells like below?

=COUNTIF(Sheet1!A13:AA39,"*David*")+(Sheet1!A57:AA53,"*David*")

Thanks,
David

Reply to this Message

Alan - 27 Nov 2006 02:33 GMT

=COUNTIF(Sheet1!A13:AA39,"*David*")+COUNTIF(Sheet1!A57:AA53,"*David*")
Regards,
Alan.

> I'm trying to perform a countif on two different ranges of cells but am
> having difficulty figuring out how to get past the first range. This is
[quoted text clipped - 10 lines]
> Thanks,
> David

Reply to this Message

T. Valko - 27 Nov 2006 02:40 GMT

Try this:

=COUNTIF(Sheet1!A13:AA39,"*David*")+COUNTIF(Sheet1!A57:AA53,"*David*")

Biff

> I'm trying to perform a countif on two different ranges of cells but am
> having difficulty figuring out how to get past the first range. This is
[quoted text clipped - 10 lines]
> Thanks,
> David

Reply to this Message