Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |