Finding sum of certain rows, Editing Cells, Changing text color,

[JamoviUser1]

Hello,

1) I have a dataset that contains participants who've had visit 1 and visit 2s, but I'd like to only sum their incomes from their visit 1s. Which steps can I take to make this happen?

2) How do I edit datasets? I'd like to replace certain cells with "No response" to ensure Jamovi doesn't count it as being 0 and instead as "No response". Which steps can I take to make that happen?

3) How do I change the text color of certain rows?

[jonathon]

take a look at computed variables to sum variables:

https://www.jamovi.org/user-manual.html ... -variables

if you want to treat particular values in a column as "missing values", double click on the column header, select 'missing values' and in there you can specify what values you want to be treated as missing values.

sorry! there's no way to set the text colour in the spreadsheet at this time.

cheers

jonathon