Hi all,
I have data in 500 rows of 15 columns
example
Total yr 05 yr06 yr07 tariff shortage damage wr blng old
1000 500 300 200 150 150 150 250 300
total = yr 05 + yr 06 + yr 07
total = tariff + shortage + damage + wr blng + old
i need formula to compute sum at xxxx (sum(if, sumproduct, or sumif( or any)
tariff shortage damage wr blng old
yr 05 xxxx xxxx xxx xxxx xxxx
yr 06 xxxx xxxx xxx xxxx xxxx
yr 07 xxxx xxxx xxx xxxx xxxx

thank u in advance