Sum formula for calculating month occurrences from dates works for everything except for January.
I am attempting to automate the calculations of how often each month is recorded in another tab. The formula is working for all the other months, but as I am using this template to calculate values as I enter them, I arbitrarily set the limit to 2000, allowing me not to have to think about changing the formula as I enter new information. Unfortunately, it seems that the blank cells are being coded as "1"
I have tried going through the formula and found that all the blank cells are coding themselves as "true" only for the month of January (1). I attempted to add
=IF(SHEET2!A3:A2000 = " ", 0, ...
to the beginning of the formula, but it just gave me a spill error. I might be getting confused between excel vs. Google Sheets formulas.
Thank you!
[link] [comments]
Want to read more?
Check out the full article on the original site