Count NOT Blank (Joining) + Certain Region

Nicole Hodges

All,

I am creating a formula on a metric sheet to COUNT NOT BLANK columns (range of several) AND if meets a certain region. I tried a few. Any tips?

=COUNTIF(ISBLANK(join{([SALESFORCE Data Error: Late Fee % or Grace Period]}:{[YARDI: Timing Charges Not Billed to Ledger]}, 1, Region@row)

Paul Newcome

Is the region a specific column?

Nicole Hodges

Yes, named "Region"

Paul Newcome

Try something along the lines of...

=COUNTIFS({Region}, Region@row, {First Column}, <> "", {Second Column}, <> "", {Third Column}, <> "", .....................................)

Nicole Hodges

ah, it (almost) worked!

I want to count if ANY of the columns are NOT Blank. Where would I add that?

=COUNTIFS({Region}, Region@row, {Lease Move in Log Range 2}, <>"", {Lease Move in Log Range 3}, <>"", {Lease Move in Log Range 4}, <>"", {Lease Move in Log Range 5}, <>"", {Lease Move in Log Range 6}, <>"", {Lease Move in Log Range 7}, <>"", {Lease Move in Log Range 8}, <>"", {Lease Move in Log Range 9}, <>"", {Lease Move in Log Range 10}, <>"", {Lease Move in Log Range 11}, <>"", {Lease Move in Log Range 12}, <>"", {Lease Move in Log Range 13}, <>"")

Nicole Hodges

It NEEDS to meet the "region" criteria but IF ANY of the other fields are NOT Blank, I want to count....

the ISBLANK at front is not working :(

Paul Newcome

Ah. Ok. I misunderstood. Thought you meant that you wanted to count for rows where ALL columns were not blank.

It will be easiest to insert a column on the source sheet (checkbox type will work well) and use a formula to check the box for any rows where there is a "non-blank" cell across your columns.

=IF(COUNTIFS([First Column]@row:[Last Column]@row, @cell <> "") > 0, 1)

Then the cross sheet formula would be as straightforward as

=COUNTIFS({Region}, Region@row, {Checkbox}, 1)

Nicole Hodges

Ah, that will do it! thank you, Paul!

Paul Newcome

Happy to help! 👍️