IF Condition & Count IF formula

RajKumar 28

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

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

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

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

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

Thanks Kimberly appreciate your help

Paul Newcome

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

RajKumar 28

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

Happy to help. 👍️