Results 1 to 5 of 5
Thread: Excel
Hybrid View
-
3rd January 2014 22:02 #1Registered User
Join Date: Nov:2005
Location: Sofia
Posts: 118
Excel
=SUMIF, . . "criteria" ">5 10<". ?
-
4th January 2014 10:55 #2Registered User
Join Date: Mar:2004
Location: In your dreams
Posts: 5,088
:
Code:=SUMIFS(A1:A25,A1:A25,">5",A1:A25,"<10")
-
4th January 2014 12:56 #3Registered 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.
-
6th January 2014 15:16 #4
-
6th January 2014 21:41 #5Registered User
Join Date: Nov:2005
Location: Sofia
Posts: 118
. , "=SUMIFS(B1:B15;A1:A15;">1900";A1:A15;"< 1902")"




Reply With Quote
R9 280,
7th May 2023, 21:28 in