smashclash
Board Regular
- Joined
- Nov 24, 2003
- Messages
- 126
- Office Version
- 365
- Platform
- Windows
Below is a preview of my worksheet. What I'm trying to get excel to do is sum column I in row 47 if the number in Column F does NOT equal 0. For some reason excel will not recognize the "<>0" to not include the 0 accounts. However, if take the same formula and replace teh<> with =, it only adds the 0's? I could probably just use multiple if statements to include everything except the 0, but there has to be a way to simply exclude anything that is a 0. Any ideas???
(one other thing, not sure if it matters, but the columns D-H are text). Thanks in advance.
(one other thing, not sure if it matters, but the columns D-H are text). Thanks in advance.