COUNTIFS various cells

[beengone]

How do I use COUNTIFS to count all >0 cells that are not in a consecutive range? For instance, I thought this would work

=COUNTIFS (D21,I21,I35,D35,D49,I49,I63,D63,D77,I77,I91,D91,D105,I105; ">0") 

But, when I put in the semicolon, it changes to a comma and I get Err:511.

Long version
I have a chart with daily totals for two people in a team/combined competition. Each day, for each person, I have a daily total points earned. I also have a weekly combined total points goal. If the current weekly progress is not at 75% of the where they should be at the current day, I want to change the color of the combined weekly total cell.

My plan was to check each of the cells named above and count all with totals >0 them so I know how many of the 14 days’ data is entered to compare to the total goal.

[erAck]

Read the COUNTIFS() help for why it does not work as you think it would (i.e. the alternating range and criteria arguments and that they are ANDed).

You can use the range union / concatenation operator ~ tilde with COUNTIF(), so

=COUNTIF(D21~I21~I35~D35~D49~I49~I63~D63~D77~I77~I91~D91~D105~I105; ">0")

Whether the ; semicolon function parameter separator is changed to , comma after input depends on your locale and separator settings. Semicolon is always accepted, other separator depends on settings, hence we use the semicolon here in examples.

[beengone]

I’ll give that a try, thanks. I read the help a few times, but didn’t understand what I needed to.