IF Condition & Count IF formula

RajKumar 28 · 10/15/21

Hi Folks,

I have a question in Formulas, My requirement is to filter the blanks in Projected CM2 column and counts the each names in CM2 Column.

Used formulas: If condition to select blanks values & count if to count the values & not work out

Any leads please advise

Thanks!

Raj

Paul Newcome · 10/15/21

So you want to count how many times there is something in both the CM2 and Projected CM2 columns ignoring rows where there is a blank cell in either of those two columns?

Try this...

=COUNTIFS([CM2]:[CM2], @cell <> "", [Projected CM2]:[Projected CM2], @cell <> "")

Kimberly Loveless · 10/15/21

So if I am understanding you want to count the number of items in CM2 that are not blank and that don't have a projected date...

Try this...

=COUNTIFS([Projected CM2]:[Projected CM2],ISBLANK(@cell),CM2:CM2,NOT(ISBLANK(@cell)))

If you are looking to just count the ones that have a projected date you would use something like...

=COUNTIF([Projected CM2]:[Projected CM2],NOT(ISBLANK(@cell)))

RajKumar 28 · 10/15/21

Hi Paul,

In the above screen shot, I have to filter (Projected CM2 ) column as Blanks & Counts the each names in the (CM2) column , As per the available in my screen shot answer would be Orbit One CM =1

RajKumar 28 · 10/15/21

https://community.smartsheet.com/discussion/comment/307925#Comment_307925

Hi Paul,

It works for me the below

=COUNTIFS([Projected CM2]:[Projected CM2], @cell = "", [CM2]:[CM2], @cell = "Orbit One CM")

RajKumar 28 · 10/15/21

Thanks Kimberly appreciate your help

Paul Newcome · 10/15/21

My apologies for misunderstanding. I'm glad you were able to get it working though.

RajKumar 28 · 10/15/21

https://community.smartsheet.com/discussion/comment/307941#Comment_307941

It ok Paul, with your ignite i can able to complete it Thank you so much

Paul Newcome · 10/15/21

Happy to help. 👍️

IF Condition & Count IF formula

Answers

Help Article Resources

Categories