Forum Discussion
Solved
#VALUE! error
I have been trying to add up (from E4 to AV4) them. However there are blank cells which I tried- TO GO special and select blank- Type 0 and Click Ctrl+Enter. But it changes only Rows and columns that...
Quiet a descriptive explanation, will be trying it for sure in the next report I prepare. Thank you so much.
I am trying your method of using tables and totaling SUM. Could you please assist me steps. As I am finding it difficult with using tables and while totaling rows, after =SUM( CONSUMPTION[AR-263]:[AR-266]])
Do I have to type what I have made BOLD.
Thanx in advance.
You don't have structured table in the file, that's just a range. To convert it to table select the range, Ctrl+T, rename the table as desired, now you may use formulas with structured references. Please check attached.
- Thank you SergeiBaklan. I understood, I was just selecting the range for the table and not creating a table. Thanx Again
Somersetinventory , you are welcome
