| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
SUMIF between 2 amounts, eg 51>x> -51
I want to sum a corresponding number in column C if the cell in column D is
between + -50. |
|
#2
|
|||
|
|||
|
Hi
one way: =SUMIF(D:D,"-50",C:C)-SUMIF(D:D,"=50",C:C) or try =SUMRODUCT(--(D1:D100-50),--(D1:D100<50),C1:C100) -- Regards Frank Kabel Frankfurt, Germany "sam158963" schrieb im Newsbeitrag ... I want to sum a corresponding number in column C if the cell in column D is between + -50. |
|
#3
|
|||
|
|||
|
=SUMIF(D:D,"="&E2,C:C)-SUMIF(D:D,""&F2,C:C)
where E2 houses -50 and F2 +50. sam158963 wrote: I want to sum a corresponding number in column C if the cell in column D is between + -50. |
|
#4
|
|||
|
|||
|
"Frank Kabel" wrote...
.... or try =SUMRODUCT(--(D1:D100-50),--(D1:D100<50),C1:C100) More compact, =SUMPRODUCT(--(ABS(D1:D100)<50),C1:C100) |
| 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 | |||
| help with "criterea" in the sumif function | Excel Worksheet Functions | |||
| How do I ask for multiple criteria when creating a "sumif" formul. | Excel Worksheet Functions | |||
| SUM(IF( Array to avoid #NUM! values | Excel Worksheet Functions | |||
| Conditional Format With SUMIF | Excel Worksheet Functions | |||
Linear Mode
