Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif between values
Hi,
I'm trying to add up the values in column C only if the the corresponding values in Column A is Equal to and between 2000 and 3000, 3000 and 4000, 4000 and 5000. A B C 1 2000 tom $10 2 2200 bob $20 3 4058 lue $50 4 3000 sue $6 5 4125 nik $8 This is what the answers should be: 2000 $30 3000 $6 4000 $58 This is what I have but I get 0 all the time. I can't figure out the criteria part: =SUMIF(A1:A5,A1:A5 AND(=2000,<3000),C1:C5) Thanks Ivano |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif between values
one way:
=SUMPRODUCT(--(A1:A5=2000),--(A1:A5<3000),(C1:C5)) See http://www.mcgimpsey.com/excel/doubleneg.html for an explanation of how the -- works. In article , Ivano wrote: Hi, I'm trying to add up the values in column C only if the the corresponding values in Column A is Equal to and between 2000 and 3000, 3000 and 4000, 4000 and 5000. A B C 1 2000 tom $10 2 2200 bob $20 3 4058 lue $50 4 3000 sue $6 5 4125 nik $8 This is what the answers should be: 2000 $30 3000 $6 4000 $58 This is what I have but I get 0 all the time. I can't figure out the criteria part: =SUMIF(A1:A5,A1:A5 AND(=2000,<3000),C1:C5) Thanks Ivano |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif with activex input | Excel Discussion (Misc queries) | |||
sumif remove high/low values | Excel Discussion (Misc queries) | |||
Min values in a list of numbers | Excel Worksheet Functions | |||
Using SumIF formulas with multiple lookup values | Excel Worksheet Functions | |||
Sumif with open Values | Excel Discussion (Misc queries) |