Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

countif function should ignore empty cells #1504

Closed
stevencohn opened this issue Jul 23, 2024 · 0 comments · Fixed by #1505
Closed

countif function should ignore empty cells #1504

stevencohn opened this issue Jul 23, 2024 · 0 comments · Fixed by #1505
Assignees
@stevencohn
Labels
bug Something isn't working released Available in a released installer

Comments

@stevencohn
Copy link
Owner

Problem to Solve

The countif function currently considers empty cells, which means tests like <2 will count an empty cell as a match, artificially inflating the result.
@stevencohn stevencohn added bug Something isn't working unread I have seen it or had time to refine it yet labels Jul 23, 2024
stevencohn added a commit that referenced this issue Jul 23, 2024
@stevencohn
#1504 ignore empty cells when processing countif
dc0835f
@stevencohn stevencohn mentioned this issue Jul 23, 2024
Merged
stevencohn added a commit that referenced this issue Jul 23, 2024
@stevencohn
1504 countif ignore empty cells (#1505)
d53f73a 
* #1504 ignore empty cells when processing countif

* 1504 resolve relateive cell ref when using (a1, a-1) syntax

* remove logger

* resx

* comment
@stevencohn stevencohn added next-release Addressed but not yet released and removed unread I have seen it or had time to refine it yet labels Jul 23, 2024
@stevencohn stevencohn self-assigned this Jul 23, 2024
@stevencohn stevencohn linked a pull request Jul 23, 2024 that will close this issue
1504 countif ignore empty cells #1505
Merged
weissm pushed a commit to weissm/OneMore that referenced this issue Jul 29, 2024
@stevencohn @weissm
1504 countif ignore empty cells (stevencohn#1505)
bc42830 
* stevencohn#1504 ignore empty cells when processing countif

* 1504 resolve relateive cell ref when using (a1, a-1) syntax

* remove logger

* resx

* comment
weissm pushed a commit to weissm/OneMore that referenced this issue Jul 29, 2024
@stevencohn @weissm
1504 countif ignore empty cells (stevencohn#1505)
268dd84 
* stevencohn#1504 ignore empty cells when processing countif

* 1504 resolve relateive cell ref when using (a1, a-1) syntax

* remove logger

* resx

* comment
@stevencohn stevencohn added released Available in a released installer and removed next-release Addressed but not yet released labels Aug 25, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@stevencohn stevencohn

Labels
bug Something isn't working released Available in a released installer
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

1504 countif ignore empty cells stevencohn/OneMore
1 participant
@stevencohn