Proton Sheets formula copying - sumifs error
Using Sumifs fomula, when copying it one row down/up (or one column to the right/left), reference cells are not correctly referenced and jump one cell. E.g. sumifs formula is copied down one cell, it now points to a reference cell 2 lines down. Same when copying it over by one column, the new reference column is now 2 over. This prevents formulas from being copied as one must adjust them all individually. Very annoying! Please could you fix this?
2
votes