Excel question

[FasterThanMeerkats]

@amarone

If each column has a header of QTY or COST, as shown in the example, there is a much easier way: The following is a solution for four QTY/COST pairs, beginning in B2 and ending in I2.

=SUMIF(B$2:I$2,“QTY”,B3:I3)
=SUMIF(B$2:I$2,“COST”,B3:I3)

These can be copied down the rows and B3:I3 will automatically change to each row to which it is copied.

Seconded. Sumifs like this are extremely useful and this one won’t require you to change your structure.

[Gary_Robson]

I must have been well and truly addled to have missed this solution. I use sumif all the time and somehow never thought of it for this. Thanks.

[MandaJo]

@Munch

Not to beat a dead horse, but merely to spread the good word - learn how to do a pivot chart. It will expand your Excel utilization far beyond that of any other task/formula available.

My mother is one of 12 geeky, geeky children. This point was really driven home when a family get together turned into a spontaneous pivot table workshop.