Dear community.
I have an issue with a formula I can't seem to get my head around.
I'm doing countifs to get the data for each month and then doing "sum" to get the total for the year (Financial year)
When I do a Countifs for the full year, there is a discrepancy on the number I get from the total done with the above method compared to what I get with the countifs formula. The correct number is the latter and I'm missing some numbers from the individual months.....
Any thoughts?
Bookmarks