# Countif across columns? example: '=countif(D1:M1, "\<45")'

**URL:** <https://community.parabola.io/t/countif-across-columns-example-countif-d1-m1-45/2056>\
**Category:** Ask a question\
**Created:** [October 12, 2021, 11:56pm UTC](https://community.parabola.io/t/countif-across-columns-example-countif-d1-m1-45/2056 "2021-10-12T23:56:40Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Joey](https://avatars.discourse-cdn.com/v4/letter/j/f14d63/32.png) [@Joey](https://community.parabola.io/u/Joey)\
**Post date:** [October 12, 2021, 11:56pm UTC](https://community.parabola.io/t/countif-across-columns-example-countif-d1-m1-45/2056/1 "2021-10-12T23:56:40Z")

</div>

Hello, I am trying to recreate a script I made with Google sheets in Parabola so that all of the data can be filted through Parabola vs Google sheets.

One function I use a lot is the ‘countif’.  
basically what I’m trying to do count across 10 columns to see if a number is equal to or less than 45.  
in excel of google sheets the syntax would look like this:

=countif(D1:M1, “\<45”)

counting if columns 1 through 10 are less than or equal to 45 then it totals how many of those columns are less than “45”, 1 through 10.

Is there a way to do this same function on parabola?

---

<div class="post-metadata">

**Author:** ![Brian\_Dawson](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/brian_dawson/32/1454_2.png) [@Brian\_Dawson](https://community.parabola.io/u/Brian_Dawson)\
**Post date:** [October 25, 2021, 7:34pm UTC](https://community.parabola.io/t/countif-across-columns-example-countif-d1-m1-45/2056/2 "2021-10-25T19:34:33Z")

</div>

Hey Joey,

Yes, there are a couple ways you could do this. In my opinion, the best method would be to “Unpivot” your columns. so that each number is now a row.

Then, do a filter step where you keep any number that is \<45.

Then, do a count by group step to count the remaining rows.

Let me know if you need any help/clarification.