M
Mike McLellan
I have an array of 6 colums (B to G) and 20 rows (2 to 21). For each row,
the entry in column A (text) defines the entries in columns B to G (numeric)
for that row. The entry in Column A is not unique and may be repeated in any
of the othger rows (2 to 21). Row 23 is a Total row. What I want to be able
to do is define a formula for each Total entry that basically says:
for each entry in column A where Axx = "value" add up the contents of the
corresponding entry in the current column (e.g. B) and place the answer in
the appropriate Total column (e.g. B23).
Can anyone help me with the formula?
the entry in column A (text) defines the entries in columns B to G (numeric)
for that row. The entry in Column A is not unique and may be repeated in any
of the othger rows (2 to 21). Row 23 is a Total row. What I want to be able
to do is define a formula for each Total entry that basically says:
for each entry in column A where Axx = "value" add up the contents of the
corresponding entry in the current column (e.g. B) and place the answer in
the appropriate Total column (e.g. B23).
Can anyone help me with the formula?