ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - sum (https://www.excelbanter.com/excel-discussion-misc-queries/205175-sum.html)

kevcar40

sum

Hi
i have 2 columns of data

Column A contains the Week number
Column B contains the production figure

A B
27 121.8857005
28 124.5395703
29 119.0771351
30 88.77096952
31 0
32 0
33 0.038461538
34 77.17431369
35 73.75013132
35 10
36 110.4825398
37 113.597772
38 83.05902338
39 77.00068555
34 276.6528609
34 62.63818451
34 77.17431369

What i want to do is :-

Count the production against each week
E F
27 121.8857005
28 124.5395703
29 119.0771351
30 88.77096952
31 0
32 0
33 0.038461538
34 493.6396728
35 83.75013132
36 110.4825398
37 113.597772
38 83.05902338
39 77.00068555
i am using this formula but it is not summing

SUMIF(INDIRECT("d2:d"&$D$1),A2,INDIRECT("B2:b"&$D$ 1))

thanks

kevin

Mike H

sum

Hi,

Put you week numbers in a column somewhere, I used D1 down. Put this in E1
and drag down

=SUMIF($A$1:$A$17,D1,$B$1:$B$17)

Mike

"kevcar40" wrote:

Hi
i have 2 columns of data

Column A contains the Week number
Column B contains the production figure

A B
27 121.8857005
28 124.5395703
29 119.0771351
30 88.77096952
31 0
32 0
33 0.038461538
34 77.17431369
35 73.75013132
35 10
36 110.4825398
37 113.597772
38 83.05902338
39 77.00068555
34 276.6528609
34 62.63818451
34 77.17431369

What i want to do is :-

Count the production against each week
E F
27 121.8857005
28 124.5395703
29 119.0771351
30 88.77096952
31 0
32 0
33 0.038461538
34 493.6396728
35 83.75013132
36 110.4825398
37 113.597772
38 83.05902338
39 77.00068555
i am using this formula but it is not summing

SUMIF(INDIRECT("d2:d"&$D$1),A2,INDIRECT("B2:b"&$D$ 1))

thanks

kevin

Roger Govier[_3_]

sum

Hi Kev

Works fine for me.
Are you using the correct columns??

--
Regards
Roger Govier

"kevcar40" wrote in message
...
Hi
i have 2 columns of data

Column A contains the Week number
Column B contains the production figure

A B
27 121.8857005
28 124.5395703
29 119.0771351
30 88.77096952
31 0
32 0
33 0.038461538
34 77.17431369
35 73.75013132
35 10
36 110.4825398
37 113.597772
38 83.05902338
39 77.00068555
34 276.6528609
34 62.63818451
34 77.17431369

What i want to do is :-

Count the production against each week
E F
27 121.8857005
28 124.5395703
29 119.0771351
30 88.77096952
31 0
32 0
33 0.038461538
34 493.6396728
35 83.75013132
36 110.4825398
37 113.597772
38 83.05902338
39 77.00068555
i am using this formula but it is not summing

SUMIF(INDIRECT("d2:d"&$D$1),A2,INDIRECT("B2:b"&$D$ 1))

thanks

kevin

All times are GMT +1. The time now is 02:58 AM.