Need to create a SUM for data in a row of cells containing IF fun.
I have a row of cells with IF functions that return a number in each cell. I
have a SUM total at the end of the row which returns a zero valuve! Why is the SUM function returning a zero value? |
Likely the IF functions are returning text digits rather than numbers.
Jerry Banana wrote: I have a row of cells with IF functions that return a number in each cell. I have a SUM total at the end of the row which returns a zero valuve! Why is the SUM function returning a zero value? |
All times are GMT +1. The time now is 02:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com