masonkingcobra
New Member
- Joined
- Jul 9, 2015
- Messages
- 1
So if I have three adjacent cells:
0 3 0
I want to keep this data. But I also want to sum these three numbers up. The issue is that the "3" is equal to a "N/A", so I dont want to include it in the sum. How can I add these three cells up without including the 3? Note that the placement of the "3" may vary in those three cells.
If A1,B1,OR C1 contain a "3" then sum the cells that do not contain a "3"
0 3 0
I want to keep this data. But I also want to sum these three numbers up. The issue is that the "3" is equal to a "N/A", so I dont want to include it in the sum. How can I add these three cells up without including the 3? Note that the placement of the "3" may vary in those three cells.
If A1,B1,OR C1 contain a "3" then sum the cells that do not contain a "3"
