Nije ovo problem za formulu, jedino bi valjalo da te svoje kolone sakupiš pod jednim imeniteljem, tj da im svima pristupaš istim imenom.
Prvo ih sve obeleži držeći pritisnut taster Ctrl, te na kraju kucaj ime u "Name box" (levo od formule). Pretpostavimo da će se zvati "zebra" - pošto otprilike prati taj šablon.
Onda se suma za svaki takav red dobija
horizontalnim presekom svih vertikala, što se postiže 'razmakom' (operator preseka), i referencom na tekući red; ovako
Code:
=SUM(zebra INDIRECT("R";))
Have you found helpful examples, solutions or ideas-in-work, please consider the
following:
• Citation of *actual page* you are going to using is welcome.
• Have you saw "Value Added" examples you are going to incorporate to your
profitable blog, daily job or any money making venture: How about online donation?
↗Ana & Vlade Divac Foundation
Hvala!