So you could say
countif(b1:e420,'50')
(question mark?)At 10:14 AM 9/25/2014, you wrote:
As mentioned by others, the countif command is yourfriend in this. The
format is =COUNTIF(first cell in the range:last cell in the range, value you
want to count)
The value can be a number, text in quotes, or the contents of another cell.
Note that if you try to count in adjacent columns you can count them all in
one operation by setting the value after the colon to the last cell in the
second column. (or third, forth, etc.)
> -----Original Message-----
> From: Jfw [mailto:[email protected]] On
> Behalf Of stintonjoe--- via Jfw
> Sent: Thursday, September 25, 2014 3:06 AM
> To: jaws users
> Subject: excel
>
> Hi all
>
> I have a sheet in excel and I want to do a formula which will first
> look at a collem and count how many times the number 50 turnse up then
> I want to do the same formaler for another collem then I want another
> cell which adds the to together .
> so how can this be done?
> I have windows 7 and jaws 12
>
> thanks in advance Joe
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://lists.the-jdh.com/pipermail/jfw_lists.the->
jdh.com/attachments/20140925/80659d3b/attachment.html>
> _______________________________________________
> Jfw mailing list
> [email protected]
> http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com
_______________________________________________
Jfw mailing list
[email protected]
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com
_______________________________________________
Jfw mailing list
[email protected]
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com
