1. Messages
  2. excel

Re: excel

Nicole Massey <nyyki@...>
 

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:jfw-bounces+nyyki=gypsyheir.com@...] 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
Jfw@...
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com
Join main@jfw.groups.io to automatically receive all group messages.