Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Hi
try =SUMIF(range,"100")-SUMIF(range,"=200) or use SUMPRODUCT: =SUMPRODUCT(--(range100),--(range<200)) See: http://www.xldynamic.com/source/xld.SUMPRODUCT.html -- Regards Frank Kabel Frankfurt, Germany hassan barjini wrote: Hi I would like to add this creiteria in sumif "and( 100 , <200)" there is no answer why ? |
#2
|
|||
|
|||
=SUMIF(A:A,"<200")-SUMIF(A:A,"<=100")
Vaya con Dios, Chuck, CABGx3 "hassan barjini" wrote in message ... Hi I would like to add this creiteria in sumif "and( 100 , <200)" there is no answer why ? |
#3
|
|||
|
|||
Opps, sorry............I didn't notice the OP's system clock was off, and
that Frank had previously answered........... Vaya con Dios, Chuck, CABGx3 "CLR" wrote in message ... =SUMIF(A:A,"<200")-SUMIF(A:A,"<=100") Vaya con Dios, Chuck, CABGx3 "hassan barjini" wrote in message ... Hi I would like to add this creiteria in sumif "and( 100 , <200)" there is no answer why ? |
#4
|
|||
|
|||
creiteria in sumif
Hi
I would like to add this creiteria in sumif "and( 100 , <200)" there is no answer why ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF Function | Excel Discussion (Misc queries) | |||
SUMIF Criteria | Excel Discussion (Misc queries) | |||
SumIF | Excel Discussion (Misc queries) | |||
SUMIF with only one criteria cell within range | Excel Discussion (Misc queries) | |||
Sum or Sumif | Excel Discussion (Misc queries) |