PDA

View Full Version : Sum particular cells



Lartk
10-31-2012, 08:17 AM
See the attached sheet. I would like column AC to be the sum of the numbers in AN. But only the sum for each section. So for example, for the first section, the AC quantity would be sum(AN9 - AN11). For the second section, the AC quantity would be the sum (AN13 - AN16), etcc.. I have the desired results highlighted on the sheet.

Bob Phillips
10-31-2012, 08:28 AM
Try this array formula

=SUM(INDEX($AN$1:$AN$25,MAX(IF($AN$7:$AN9="",ROW($AN$7:$AN9)))):INDEX($AN$1:$AN$25,MIN(IF($AN9:$AN$25="",ROW($AN9:$AN$25)))))

Lartk
10-31-2012, 08:50 AM
That works, thanks!