Forum Discussion
If and Sum Nested formula
This is what I have =if(b9:F9=0,"",B9:F9). Obviously it's not working lol. I'm having trouble with the false. According to my assignment, it's supposed to display the sum if it is false. here is ...
I have a above formula in column but I need a Sum of this column ang SUM formula is showing 00:00
The values in column F are left-aligned. That suggests they might be text values.
Try the following:
- Select column F.
- Set the number format to a time format,
- On the Data tab of the ribbon, click Text to Columns.
- Click Finish.
Does that make a difference?