Sumproduct with conditions
Hi,
Many thanks to all those who've helped me out previously!
My latest problem is that I have a large worksheet of data. I need to find
out how many times an operators number has appeared in column (Column F) and
what the results were of a particular measurement (Column M). I'm
constructing a balanced scorecard that reads from various other workbooks and
have got those to work, however this is the only book where the data is
ranged differently. The operator numbers do not appear sequentially, just as
and when they happen to have been measured.
Any help, as always, greatly appreciated!
Jason
|