MATCH, SUM
 

I have identifiers in column A which may be duplicated, then I have the
federal tax in column B and state tax in column C. If the identifier is the
same in column A, I would like to sum the B and C columns.

MATCH, SUM
 

Hi

Have you considered using a pivot table to summarise the data?

Otherwise, a formula option could include:

=SUMPRODUCT(--(A2:A1000="YourIdentifier"),B2:B1000,C2:C1000)

You would need to replace "YourIdentifier" with whatever identifier
value you have (or with a reference to a cell containing that value).
You can adjust your ranges to suit.

Hope this helps!

Richard


mwoody wrote:

I have identifiers in column A which may be duplicated, then I have the
federal tax in column B and state tax in column C. If the identifier is the
same in column A, I would like to sum the B and C columns.

MATCH, SUM
 

try
=sumproduct((a2:a22=id)*b2:c22)

--
Don Guillett
SalesAid Software

"mwoody" wrote in message
...
I have identifiers in column A which may be duplicated, then I have the
federal tax in column B and state tax in column C. If the identifier is
the
same in column A, I would like to sum the B and C columns.

MATCH, SUM
 

=SUMPRODUCT(--(COUNTIF(A2:A100,A2:A100)1)*B2:C100)


"mwoody" wrote:

I have identifiers in column A which may be duplicated, then I have the
federal tax in column B and state tax in column C. If the identifier is the
same in column A, I would like to sum the B and C columns.

MATCH, SUM
 

My original was wrong, it should be amended:

=SUMPRODUCT(--(A2:A1000="YourIdentifier"),B2:B1000+C2:C1000)

or you could use:

=SUM(IF(A2:A100="Identifier",B2:C100))

which is an array formula confirmed with Ctrl+Shift+Enter

Richard




RichardSchollar wrote:

Hi

Have you considered using a pivot table to summarise the data?

Otherwise, a formula option could include:

=SUMPRODUCT(--(A2:A1000="YourIdentifier"),B2:B1000,C2:C1000)

You would need to replace "YourIdentifier" with whatever identifier
value you have (or with a reference to a cell containing that value).
You can adjust your ranges to suit.

Hope this helps!

Richard


mwoody wrote:

I have identifiers in column A which may be duplicated, then I have the
federal tax in column B and state tax in column C. If the identifier is the
same in column A, I would like to sum the B and C columns.