user11214808
Reputation:
Formula to Find Count of Odd Numbers in Google Sheets
I have 500 numbers (range A1:T25) and I have to find a formula to find the count of the odd numbers in that range. I do not see any way to use COUNTIF or ISODD or MOD (by 2). I am no expert in spreadsheet functions at all, so I do not know how to do this.
Upvotes: 1
Views: 1503
Answers (1)
player0
Reputation: 1
try it like this:
=ARRAYFORMULA(COUNTIF(ISODD(A1:T25); TRUE))
=SUMPRODUCT(ISODD(A1:T25)) @Tom SharpeUpvotes: 3
Related Questions
- google sheets count array elements
- Sum Each Row in Array (Google Sheets)
- Google Sheets Query get Even/Odd rows in grouped results
- Google Sheets / Count instances in only odd rows of an array
- Count sub arrays with atmost k odd numbers
- count number of subarrays with odd sum
- How to count and list odd numbers in an array
- Sum odd cell values if even cells are not empty
- Excel 2007 COUNTIF in even rows only
- Find the first occurrence of an odd and count them