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...
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?
- D7 will be around 167 as result
D6 could be around 15 as result as well.- If D7 is supposed to count all the TRUE values in Worksheet!$AY$8:$AY$1900 then the correct formula in D7 is:
=COUNTIF(Worksheet!$AY$8:$AY$1900,TRUE)