Net results, one formula, unable to find/calc

English
, ,
#1

Please review Calc file…

TEST.ods (18.2 KB)
looking for one calculation or one formula that will meet all calculations
NET Total of Group A & Group B, below does not contain any calc
just numbers that I would like to see and looking for a formula that will convert all in a sweep instead of setting individually

thank U in advance

#2

I think I know what you mean, {=(C10:C24)+(C28:C42)} , don’t add the curly brackets, instead press Ctrl+Shift+Enter to create the array
TEST117401EA.ods (18.5 KB)

BTW You will have to work out for yourself if you are subtracting or adding cells, at the moment your sample is inconsistent

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.