My spreadsheet is perfect as is however its taking a while to save because the formula is reading columns instead of a small database.
Excel 1.png
When i modify the below formula,
=COUNTIFS($B:$B,">="&N1,$B:$B,"<="&N2,$C:$C,"Pending")
To this:
=COUNTIFS($B$5:$B$100,">="&N1,$B$5:$B$100,"<="&N2,$C$5:$C$100,"Pending")
Cell N4 returns": #VALUE.
Why is this not working?
Bookmarks