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?

Sumproduct should handle that for you:
http://www.contextures.com/xlFunctio...tml#SumProduct
http://www.contextures.com/xlFunctio...tml#SumProduct

If you need more help post back, with a lottle more information.

Good luck,
Ryan---


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Mike McLellan" wrote:

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?

Hi,

Please refer to Data Subtotal

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Mike McLellan" wrote in message
...
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?