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...
The formulas in there are not necessarily wrong, it depends on what exactly you are intending to count. Example: D4 counts all cells in column CS which contain the number 2. There is no way for me to decide whether that is the correct way to determine how many rows are about "wiring and switch". You know the business logic which determines what exactly needs to be counted.
There are some simple mistakes however. For example, many of the formula's in D do not point to the same rows as other formulas in column D. This is bad practice which you can easily avoid by converting your data on "Worksheet" to a table. See https://jkp-ads.com/Articles/Excel2007Tables.asp
There are some simple mistakes however. For example, many of the formula's in D do not point to the same rows as other formulas in column D. This is bad practice which you can easily avoid by converting your data on "Worksheet" to a table. See https://jkp-ads.com/Articles/Excel2007Tables.asp
can you check the D11 row I am getting a negative number which is not the case.
Would you checking please for me
Would you checking please for me
- This forum is meant to post specific questions about things you are trying to do in Excel but have not succeeded in yet. So we need:
- A clear description of your problem
- What you have tried so far
- A correct example of the expected outcome