Excel Formula Question- COUNTA

[Alane]

Hello,

I have a formula that excludes certain text in cells, and counts everything else- but I want it in addition to counting the cells that exclude the text, sum up the costs in the next column. So far I have this which works in counting all the cells that DO NOT contain the texts:



=COUNTA(client name OE'!J2:J2418)-SUMPRODUCT(--('client name OE'!J2:J2418={"DECLINED","NOTOFFERED","INELIGIBLE","MAINTAIN",""""})).

So column A (Acc), counts all the text that does NOT contain "DECLINED","NOTOFFERED","INELIGIBLE","MAINTAIN","""", then I want it to sum up the costs in the next column. So for the example below, it should look at ACCEE2, ACCEE, ACCECH, then add the costs next column.

[TABLE="width: 300"]
<tbody>[TR]
[TD]Acc[/TD]
[TD]AccCost[/TD]
[/TR]
[TR]
[TD]DECLINED[/TD]
[TD]0.00[/TD]
[/TR]
[TR]
[TD]MAINTAIN[/TD]
[TD]13.00[/TD]
[/TR]
[TR]
[TD]NOTOFFERED[/TD]
[TD]0.00[/TD]
[/TR]
[TR]
[TD]MAINTAIN[/TD]
[TD]50.00[/TD]
[/TR]
[TR]
[TD]ACCEE2[/TD]
[TD]70.00[/TD]
[/TR]
[TR]
[TD]ACCEE[/TD]
[TD]25.00[/TD]
[/TR]
[TR]
[TD]ACCECH[/TD]
[TD]30.00[/TD]
[/TR]
[TR]
[TD]MAINTAIN[/TD]
[TD]50.00[/TD]
[/TR]
[TR]
[TD]DECLINED[/TD]
[TD]0.00[/TD]
[/TR]
</tbody>[/TABLE]