=count

christian alejandro · 11/12/19

I am trying to count the cells that are not blank based on a repetitive criterion

I have this formula

= count ([Find # 1]: [Find # 8], [Line / Area]: [Line / Area], "40100"

It is not accepted to place a criterion on this count, how can I do it?

regards

Andrée Starå · 11/13/19

Hi Christian,

Not sure I follow!

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Paul Newcome · 11/13/19

Check out the COUNTIFS function. It will allow you to count based on set criteria within specific ranges.

=count

Comments

Categories