Dear all,
How can I get sum for range of value depending start&end values?
I need sum of values with *.
I hope it is clear thanks in advance.
start end sum
1912 1916 ???
1910 1
1911 2
1912 3*
1913 4*
1914 5*
1915 6*
1916 7*
1917 8
1918 9
1919 10
1920 11
1921 12
Last edited by excelsorusor; 10-16-2018 at 04:03 PM.
Hi & welcome to the board.
How about
=SUMIFS(B4:B13,A4:A13,">=" &A3,A4:A13,"<="&B3)
cap01.JPG
Thank you for your reply, I entered the formula but it gave me 0.
Did I enter it wrong?
Regards.
To explain better I added this image.
Last edited by excelsorusor; 10-16-2018 at 04:15 PM.
With that layout, it should be looking in A2 & B2, not A3 & B3
It works fine thank you very much.
Glad to help & thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks