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

Sumproduct with conditions
 

Hi Jason

It sounds as if you could use Countif/Sumif for this:

=COUNTIF(F:F,<OperatorNumber)

for the number of times this operator appears in col F and:

=SUMIF(F:F,<OperatorNumber,M:M)

for the sum of all the measurements relating to this operator.

Does this do what you want or have I misunderstood?

Best regards

Richard



On 15 Mar, 10:24, JDB wrote:
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

Sumproduct with conditions
 

Thanks Richard!

The SUMIF formula was bang on!

Jason.

"RichardSchollar" wrote:

Hi Jason

It sounds as if you could use Countif/Sumif for this:

=COUNTIF(F:F,<OperatorNumber)

for the number of times this operator appears in col F and:

=SUMIF(F:F,<OperatorNumber,M:M)

for the sum of all the measurements relating to this operator.

Does this do what you want or have I misunderstood?

Best regards

Richard



On 15 Mar, 10:24, JDB wrote:
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