Forum Discussion
Excel Sheet Specific Formula not working
I have specific Excel Spreadsheet which needs to have a correct results of the formula. The formulas are working however the data within the Excel Sheet are not corresponding. Any helpful answers wil...
Without seeing your Excel file, this is really hard to trouble-shoot. Can you perhaps create and upload an anonymized version of the file that shows the same problem?
will it be possible to access my laptop remotely and take a look the excelsheet?
- I'm sorry, I do not offer free support like that. Looking at an anonymized copy you upload here (or share a link to download) is what I can offer.
JKPieterse I did update and there are 2 spreadsheet.
the first one is the worksheet where the data is collected
the statistic where the data is represent in an analytical or table data.
I am more concern the 1st table specially Column D (current) where each row has its own data after applying the formula. I am thinking its more about the formula for the subtotal which display the wrong data then realized the calculation of the data in the whole table need to be verify or look at it.
I just upload the file as per requested.
Any guidance or advice will be greatly appreciated it.
- So which cell(s) show wrong results and what is the expected outcome of those cells? For example, if it is D7 then what number are you expecting to see in D7?
