| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
the proper use of sumif
How can I sum B1:B33 if A1:A33 is in between 50 and 70 ?
I have tried this, but I only got 0 =SUMIF(A1:A33, "AND(50, <70)", B1:B33) Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
the proper use of sumif
=SUMIF(A1:A33,"50")-SUMIF(A1:A33,"70")
this will include 70, use = if you want to exclude it. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Lamb Chop" wrote in message ... How can I sum B1:B33 if A1:A33 is in between 50 and 70 ? I have tried this, but I only got 0 =SUMIF(A1:A33, "AND(50, <70)", B1:B33) Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
the proper use of sumif
Do you mean SUMIF can only have simple, "", "<" and "=" comparison and all
the AND and OR functions won't work in SUMIF? Thanks "Bob Phillips" wrote in message ... =SUMIF(A1:A33,"50")-SUMIF(A1:A33,"70") this will include 70, use = if you want to exclude it. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Lamb Chop" wrote in message ... How can I sum B1:B33 if A1:A33 is in between 50 and 70 ? I have tried this, but I only got 0 =SUMIF(A1:A33, "AND(50, <70)", B1:B33) Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
the proper use of sumif
Indeed I do.
You can use the technique I showed for simple conditions, or you can use =SUMPRODUCT(--(A1:A3350),--(A1:A33<=70),A1:A33) which can be extended to much more complex formulae. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Lamb Chop" wrote in message ... Do you mean SUMIF can only have simple, "", "<" and "=" comparison and all the AND and OR functions won't work in SUMIF? Thanks "Bob Phillips" wrote in message ... =SUMIF(A1:A33,"50")-SUMIF(A1:A33,"70") this will include 70, use = if you want to exclude it. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Lamb Chop" wrote in message ... How can I sum B1:B33 if A1:A33 is in between 50 and 70 ? I have tried this, but I only got 0 =SUMIF(A1:A33, "AND(50, <70)", B1:B33) Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
| Sumif of Sumif perhaps? | Excel Discussion (Misc queries) | |||
| SUMIF | Excel Worksheet Functions | |||
| SUMIF with Mutiple Ranges & Criteria | Excel Discussion (Misc queries) | |||
| Using PROPER for Columns, rows or ENTIRE spreadsheet | Excel Worksheet Functions | |||
Hybrid Mode
