Google-sheets – Mixing strings and calls in Google sheets

google sheets

I'm making a spreadsheet of a tabletop game character sheet and I don't want to use multiple cells for the Attack bonus to save space.

Essentially I'm trying to make it end up looking like

15/10/5

I need to input the =SUM(I21:O21) then take that total and -5, then take that total and -5, then do it once more.

I just need to show each step.

Assuming =SUM(i21:021) is 30 it should come out as 30/25/20/15

How would I do this in a cell?

Best Answer

the ampersand & functions as a simple concatenate:

=SUM(E10:E13)&"/"&SUM(E10:E13)-5&"/"&SUM(E10:E13)-10&"/"&SUM(E10:E13)-15

Related Solutions

Google-sheets – How to read a multiple values in cell in each row (separated by comma) in a Google Spreadsheet

I have assumed the last two rows are incomplete rather than a guide to your requirement, so would suggest:

=if(iserror(find(C$1,$B2)),"",1)

in the column labelled aaa and the row labelled abc, copied across and down to suit.

Google-sheets – Searching through sheets

You can use the SUMIF formula to perform this type of calculation.

Formula

=SUMIF(Sheet2!A:A, A1, Sheet2!B:B) + SUMIF(Sheet3!A:A, A1, Sheet3!B:B)

Screenshot

Sheet2 & Sheet3
enter image description here

result
enter image description here

Explained

The first parameter of the SUMIF formula takes on the criterion range (column A in your example). The second parameter is the criterion itself. I needs to look for the entry in sheet 1 in column A: A1. The third parameter is the range to sum (if it differs from the criterion range), if the criterion is met.