Results 1 to 5 of 5

Thread: Excel

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User
    Join Date: Nov:2005
    Location: Sofia
    Posts: 118

    Excel

    =SUMIF, . . "criteria" ">5 10<". ?

  2. #2
    Registered User
    Join Date: Mar:2004
    Location: In your dreams
    Posts: 5,088
    :

    Code:
    =SUMIFS(A1:A25,A1:A25,">5",A1:A25,"<10")

  3. #3
    Registered User
    Join Date: Nov:2005
    Location: Sofia
    Posts: 118
    . :
    A ; B
    1900 ; 2
    1901 ; 3
    1902 ; 1
    1903 ; 1
    1904 ; 4
    1905 ; 1
    =SUMIF(A2:A6;"<1902";B2:B6), 5
    .
    Last edited by niksan05; 5th January 2014 at 03:41.

  4. #4
    Registered User mermaid's Avatar
    Join Date: Aug:2005
    Location:
    Posts: 850
    ...
    :
    , ">1" "<4", .. .

    Click image for larger version. 

Name:	1.jpg 
Views:	91 
Size:	46.2 KB 
ID:	66122

  5. #5
    Registered User
    Join Date: Nov:2005
    Location: Sofia
    Posts: 118
    . , "=SUMIFS(B1:B15;A1:A15;">1900";A1:A15;"< 1902")"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |