COUNTA-COUNTIF help

[Jedi Master]

Good Day All. I need a little help finishing a formula. I need to count all cells (as an each) (no matter what they contain) and subtract out all the zero value cells and I cant get it to work quite correctly. In the below example, I should be getting a value of 5 (M24 through Q24). the rest of the formula refers to the following values: '2-Quote Master'!V50 = 2375

Current Formula: =IF([@Column6]="","",COUNTA((PMProjectTracker[@[Column12]:[Column558]]),-COUNTIF(PMProjectTracker[@[Column12]:[Column558]],">0"))*('2-Quote Master'!V50/[@Column3]))

The math the formula should be doing: 5*(2375/5)
5*475
=2375

 

[Fluff]

How about

=IF([@Column6]="","",SUM(COUNTIFS(PMProjectTracker[@[Column12]:[Column558]],{">0","*"}))*('2-Quote Master'!V50/[@Column3]))

 

[Jedi Master]

How about

=IF([@Column6]="","",SUM(COUNTIFS(PMProjectTracker[@[Column12]:[Column558]],{">0","*"}))*('2-Quote Master'!V50/[@Column3]))

Of course that works perfectly, thank you. Could you please explain how the following portion works: {">0","*"}. My question specifically is what are "{" and "*" doing?

 

[Fluff]

The {} denotes an array & it's counting numbers greater than 0 & any cells with text