Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF
Hi boys and girls
I have 2 colums i need to sort, first on postal number and second weight between 0 and 3 kg Col. A Col.B 0141 3 0145 7 0189 2 0176 1 0188 3 2100 6 2100 2 3350 2 6893 2 0149 12 The colums can be with 10000 rows What i want is : If col.A are between postalnumber 0 and 0999 AND col.B are between 0 and 3 kg i need the sum of all weights between 0 and 3 kg The same function for postalnumber between 1000 and 1999, and between 0 and 3 kg The same function for postalnumber between 2000 and 2999, and between 0 and 3 kg If col.A are between postalnumber 0 and 0999 AND col.B are between 4 and 5 kg i need the sum of all weights between 4 and 5 kg The same function for postalnumber between 1000 and 1999, and between 4 and 5 kg Also need a count of the same, how many 0 to 3 kg there are if postalnumbers are between 0 and 0999 Also need a count of the same, how many 0 to 3 kg there are if postalnumbers are between 1000 and 1999 Hope I explaned it right I basicly need to know how I can set 2 conditions to the SUMIF AND COUNTIF FUNCTIONS The first condition is that the value i col A is between 0 and 0999 (1000 and 1999 and so on) The second is that the value in col B is between 0 and 3 kg (4 and 5 kg, 6and 8 and so on) Hopefull user Rock Just a regular user |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" | Excel Worksheet Functions | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
SUMIF | Excel Discussion (Misc queries) | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |