a new question...
In column S, I have total cost on contracts, but the formula I am using
=SUM(S7:S23) totals all, but I need it to remove row 9 and 22 cause they were
identified in column F as "not participating". How would the formula be that
adds all amounts in column S and subtracts row 9 and 22 under the column F
identified with an "X" as in previous question.

"Eduardo" wrote:

Hi,
Be careful your column A it supposed to be the number of contracts as per
your post and column F where you put an X to indicate that the project has
been discontinued
In the formula you sent you are entering X in column A and not counting it

"Geauxfish" wrote:

I think this fixed it,

=SUMPRODUCT((F7:F23<"X")*(A7:A23<"X"))

"Geauxfish" wrote:

that adds the rows with text (landscape contracts) in column I; rows(I7:I23),
but also need to subtract that total number of (landscape contracts) from
columns A (a7:a23) and column F (f7:f23) that contain an "X", indicating the
contracts have been "discontinued" or are "not participating". In this case,
I have 17 contracts and can get the formula to tell me that, but am having
trouble getting the formula to look thru column A and F and find the "X" and
to subtract those contracts to get me my total. It should pick up two "X"'s
and subtract them from 17 contracts to give me 15 total. Can anyone help.
Thanks