Formula Help to Add Columns that Contain Text
Closed
stephd22
venkat1926
- Posts
- 1
- Registration date
- Tuesday June 24, 2014
- Status
- Member
- Last seen
- June 24, 2014
venkat1926
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Related:
- Formula Help to Add Columns that Contain Text
- Excel conditional formatting formula based on another column ✓ - Forum - Excel
- Formula to match two columns in excel - Guide
- Need a formula to sum a column with #Value error ✓ - Forum - Excel
- Excel add column if another column equals ✓ - Forum - Excel
- Excel formula to match two columns ✓ - Forum - Excel
1 reply
venkat1926
Jun 25, 2014 at 06:17 AM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
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
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