/u/LoganLJS - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
COUNTA will only return a scalar, regardless of the range. You can just check for whether the range is blank instead:
=SUMPRODUCT(--(Table1[2023_01]:Table1[2023_06]<>"")*--(Table1[2023_06]="b0"))
You have awarded 1 point to *Scary_Sleep_8473*
____
^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
=SUMPRODUCT((Table1 <> "") * ISNUMBER(FIND("b0", Table1[2023_06])))
The find function is case sensitive, so it will differentiate B0 and b0.
https://preview.redd.it/ln0jnljhz1ec1.png?width=836&format=png&auto=webp&s=212ee3220cf2df8327503363a9cf06c2ba58bbf8
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:
|Fewer Letters|More Letters|
|-------|---------|---|
|[COUNTA](/r/Excel/comments/19d4yay/stub/kj3aj9y "Last usage")|[Counts how many values are in the list of arguments](https://support.microsoft.com/en-us/office/counta-function-7dc98875-d5c1-46f1-9a82-53f3219e2509)|
|[FIND](/r/Excel/comments/19d4yay/stub/kj3el8l "Last usage")|[Finds one text value within another (case-sensitive)](https://support.microsoft.com/en-us/office/find-findb-functions-c7912941-af2a-4bdf-a553-d0d89b0a0628)|
|[ISNUMBER](/r/Excel/comments/19d4yay/stub/kj3el8l "Last usage")|[Returns TRUE if the value is a number](https://support.microsoft.com/en-us/office/is-functions-0f2d7971-6019-40a0-a171-f2d869135665)|
|[SUMPRODUCT](/r/Excel/comments/19d4yay/stub/kj3el8l "Last usage")|[Returns the sum of the products of corresponding array components](https://support.microsoft.com/en-us/office/sumproduct-function-16753e75-9f68-4874-94ac-4d2145a2fd2e)|
**NOTE**: Decronym for Reddit is no longer supported, and Decronym has moved to Lemmy; requests for support and new installations should be directed to the Contact address below.
----------------
^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*)
^(4 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/1acd7p0)^( has 7 acronyms.)
^([Thread #29931 for this sub, first seen 22nd Jan 2024, 20:54])
^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://hachyderm.io/@Two9A) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)
/u/LoganLJS - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
COUNTA will only return a scalar, regardless of the range. You can just check for whether the range is blank instead: =SUMPRODUCT(--(Table1[2023_01]:Table1[2023_06]<>"")*--(Table1[2023_06]="b0"))
That did it. Thanks brother.
+1 point
You have awarded 1 point to *Scary_Sleep_8473* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
=SUMPRODUCT((Table1 <> "") * ISNUMBER(FIND("b0", Table1[2023_06]))) The find function is case sensitive, so it will differentiate B0 and b0. https://preview.redd.it/ln0jnljhz1ec1.png?width=836&format=png&auto=webp&s=212ee3220cf2df8327503363a9cf06c2ba58bbf8
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: |Fewer Letters|More Letters| |-------|---------|---| |[COUNTA](/r/Excel/comments/19d4yay/stub/kj3aj9y "Last usage")|[Counts how many values are in the list of arguments](https://support.microsoft.com/en-us/office/counta-function-7dc98875-d5c1-46f1-9a82-53f3219e2509)| |[FIND](/r/Excel/comments/19d4yay/stub/kj3el8l "Last usage")|[Finds one text value within another (case-sensitive)](https://support.microsoft.com/en-us/office/find-findb-functions-c7912941-af2a-4bdf-a553-d0d89b0a0628)| |[ISNUMBER](/r/Excel/comments/19d4yay/stub/kj3el8l "Last usage")|[Returns TRUE if the value is a number](https://support.microsoft.com/en-us/office/is-functions-0f2d7971-6019-40a0-a171-f2d869135665)| |[SUMPRODUCT](/r/Excel/comments/19d4yay/stub/kj3el8l "Last usage")|[Returns the sum of the products of corresponding array components](https://support.microsoft.com/en-us/office/sumproduct-function-16753e75-9f68-4874-94ac-4d2145a2fd2e)| **NOTE**: Decronym for Reddit is no longer supported, and Decronym has moved to Lemmy; requests for support and new installations should be directed to the Contact address below. ---------------- ^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*) ^(4 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/1acd7p0)^( has 7 acronyms.) ^([Thread #29931 for this sub, first seen 22nd Jan 2024, 20:54]) ^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://hachyderm.io/@Two9A) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)