| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum
thanks work a treat
On 6 Oct, 11:37, Mike H wrote: 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- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
