Prev: Transfering a changing cell value progressively through a work
Next: printing
From: Brian on 4 Feb 2010 17:09
Column B in my spreadsheet consists of 10 rows with one letter in each cell.

I would like a formula to count cells B1,B3,B5,B7 and B9 only if the value
in each of those cells is "H". I have tried a simple formula like this
=countif(B1,B3,B5,B7,B9,"H") but it does not work.

Thanks for your help with this formula.

--
Brian
From: Bob Phillips on 4 Feb 2010 17:18
Try

=SUMPRODUCT(--(MOD(ROW(B1:B9),2)=1),--(B1:B9="H"))

HTH

Bob

"Brian" <Brian(a)discussions.microsoft.com> wrote in message
news:0F4B5C54-D6DC-47E5-A198-5AD7FE281C5E(a)microsoft.com...
> Column B in my spreadsheet consists of 10 rows with one letter in each
> cell.
>
> I would like a formula to count cells B1,B3,B5,B7 and B9 only if the value
> in each of those cells is "H". I have tried a simple formula like this
> =countif(B1,B3,B5,B7,B9,"H") but it does not work.
>
> Thanks for your help with this formula.
>
> --
> Brian


From: Lars-�ke Aspelin on 4 Feb 2010 17:21
On Thu, 4 Feb 2010 14:09:01 -0800, Brian
<Brian(a)discussions.microsoft.com> wrote:

>Column B in my spreadsheet consists of 10 rows with one letter in each cell.
>
>I would like a formula to count cells B1,B3,B5,B7 and B9 only if the value
>in each of those cells is "H". I have tried a simple formula like this
>=countif(B1,B3,B5,B7,B9,"H") but it does not work.
>
>Thanks for your help with this formula.

Try this formula:

=(B1="H")+(B3="H")+(B5="H")+(B7="H")+(B9="H")

Hope this helps / Lars-�ke
 | 
Pages: 1
Prev: Transfering a changing cell value progressively through a work
Next: printing