Re: excel


Laura Channon
 

The formula could be an if formula. If (cell) equals three, enter 1 in (next cell). Then do a summary of the counts of 1. For both columns where 1 appears.

=b1+d1. Would appear in say, e1.


Sent from my iPhone

On 2014-09-25, at 5:06 AM, stintonjoe--- via Jfw <jfw@...> wrote:

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.