Google Sheets – How to Sum Fractions

google sheets

I have this fraction in Google Sheets:

1/8
2/8
3/8
4/8
5/8
6/8
7/8
8/8

How do I sum this digits?
For example if I have:

1 4/8 + 3/8 = 1 7/8

How do I make this formula?
I have formatted my cells like #\ ?/8

Best Answer

you can sum cells:=A8+A4+A3

you can create named ranges:

=_88+_48+_38

or use combination:

=1+_48+_38

Related Solutions

Google-sheets – How to zero out cell if filtered sum is less than 0

For your first question, I'd expect the MAX() function to give you what you need.

=MAX(SUM(A1:A5),0)

MAX() returns the maximum value in a list of arguments. In this case, if the SUM() returns a value less than zero (i.e., negative) it'll return the zero instead.

Google Sheets – Conditional Cumulative Sum Using Arrayformula in Google Sheets

If the data starts in row 2, then try:

=ArrayFormula(IF(A2:A="A",SUMIF(IF(A2:A="A",ROW(A2:A),ROWS(A:A)+1),"<="&ROW(A2:A),B2:B),))

Best Answer

Related Solutions

Google-sheets – How to zero out cell if filtered sum is less than 0

Google Sheets – Conditional Cumulative Sum Using Arrayformula in Google Sheets

Related Topic