AntBlabby8
Board Regular
- Joined
- Apr 18, 2002
- Messages
- 192
I have a very wide spreadsheet, with many columns. In three columns--L, T, and AB--I have an IF formula that can render a sum of three columns to the left in each case, or the text "NO PRODUCT." In Col. AF, I then have a formula that says on Row 3, for example, =SUM(L3,T3,AB3). The problem I am having is if there is NO PRODUCT in either L, T, or AB, I am getting a VALUE! error. And because any or all of the three can have this NO PRODUCT in it, I don't know how to write a formula to get a total, and not a value error. HELP!