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).
I don't understand how you removed cut and paste cells. My whole data sheet had been pasted into this workbook. Can you explain how you fixed it? Thanks!!