Countifs and Sum in same column

Eric Garcia

I am trying you count checkmarks in individual columns and total up at the bottom for a score on a specific project(column) and then region (multiple columns). Please and thank you

Desired output is data to measure consistency in best management practices across a fleet

Paul Newcome

You would have to hardcode row numbers in. Instead, you could put the scores at the top and indent the rows underneath so you can use hierarchy based functions such as CHILDREN() and DESCENDENTS().

Eric Garcia

Still need help but I just figured out +""

I'm going home for the day

Eric Garcia

@Paul Newcome am I on a path here:

Genevieve P.

Hey @Eric Garcia

For your Regional Score, try simply adding together the 4 cells in the row above, with a VALUE wrapped around them:

=VALUE(Tammaron$21) + VALUE(Tehale$21) + VALUE(Valor$21) + VALUE(Verterra$21) + ""

Cheers,

Genevieve