Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Frank Kabel
 
Posts: n/a
Default

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   Report Post  
CLR
 
Posts: n/a
Default

=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   Report Post  
CLR
 
Posts: n/a
Default

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   Report Post  
hassan barjini
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
SUMIF Function Peter Curtis Excel Discussion (Misc queries) 2 January 12th 05 03:02 PM
SUMIF Criteria Brent Martin Excel Discussion (Misc queries) 6 January 7th 05 06:17 AM
SumIF anuita Excel Discussion (Misc queries) 1 January 4th 05 07:06 PM
SUMIF with only one criteria cell within range Stan Excel Discussion (Misc queries) 5 December 16th 04 11:12 PM
Sum or Sumif Frank Kabel Excel Discussion (Misc queries) 1 December 15th 04 10:56 PM


All times are GMT +1. The time now is 04:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"