The attached worksheet has totals at cells C31 through M31. Every cell in columns C through M will have an X or be blank. Column N will contain numbers. The totals cells need to add the number in column N each time an X is placed in its corresponding column. The numbers in column N can be used in the totals cells multiple times.



In the attached example: Cells E6, E12, E14, E27 and E29 have an X and are totaled at cell E31 using the corresponding numbers in column N.

I would like the cells in the totals row to add the numbers from column N each time an X is placed in the cells in its corresponding column.

Thanks so much.

Attached Files

Excel sample.xls (16.0 KB, 17 views)

Try setting up a work column outside of the table and use it as a work area. See attached.

Attached Files

Copy of Excel sample.xls (20.0 KB, 20 views)

That works for me. Thanks