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 <[email protected]> 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 > [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
