| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
