Forum Discussion
Solved
Countif formula not counting correctly
I have been trying to insert a =COUNTIF formula (and consequently, SUMIF formulas) for several days. However, I keep having the recurring issue of either, the values totally to 0 - or most recently t...
- It's difficult to offer a solution without seeing the workbook. It might be worth making your ranges specific in the COUNTIF and SUMIF instead of pointing to entire columns (e.g. A:A or I:I).
Can you add a screenshot or upload a file without sensitive data which shows the data and the applied formulas?
Unfortunately not I'm afraid - but thankfully I've finally managed to figure out what was wrong! I think it was due to the text format in column A being slightly wrong which I've amended and that seems to have worked. Thanks so much for your help. OliverScheurich