Create a formula using countif for each of the columns you want to
check, then add them together.
if you wanted columit would beample, rows 1 through 20,
countif(b1:b20),'50')
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
