Formula Help to Add Columns that Contain Text

Closed
stephd22
Posts
1
Registration date
Tuesday June 24, 2014
Status
Member
Last seen
June 24, 2014
- Jun 24, 2014 at 11:57 AM
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
- Jun 25, 2014 at 06:17 AM
I want to add the total of Column A (going to be text) and Subtract Column D if there is an "x". How do I do that formula? Anyone able to help? Example: If I have 10 rows filled out in Column A but have an X marked in Column D for 3 of those, how do I get a total of 7?

1 reply

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
808
Jun 25, 2014 at 06:17 AM
data in col A B C D from row 1 as follows

1 random data random data
2 random data random data
3 random data random data
4 random data random data x
5 random data random data
6 random data random data
7 random data random data x
8 random data random data
9 random data random data x
10 random data random data


use in any empty cell this formula

=SUMPRODUCT((D1:D10<>"x")*(A1:A10))

it will give 35
0