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 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jun 25, 2014 at 06:17 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jun 25, 2014 at 06:17 AM
Related:
- Formula Help to Add Columns that Contain Text
- Pdf and xps add in 2007 - Download - Other
- How to add @ in laptop - Guide
- Add accent over e - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Date formula in excel dd/mm/yyyy - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jun 25, 2014 at 06:17 AM
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
