Skip Cell In Column Sum 2

[tj007]

Hi

I would like to add the values in a column, but two cells must be omitted during the calculation. Here is the formula: =COUNTIF(D1425,">0&quot*0.02083333333. I need to skip cellS D18&D19 and count D1417 & D2025. I have tried the following: =COUNTIF(D14172025,">0&quot*0.02083333333 but it does not work.

 

[bluedragon2]

Try:

=(COUNTIF(D1417,">0&quot*0.02083333333)+(COUNTIF(D2025,">0&quot*0.02083333333)



Blue

If I wasn't Blue, I would just be a Dragon...

 

[SkipVought]

Hi,

How 'bout SUBTRACTING?

=(COUNTIF(D14:D25,">0")-COUNTIF(D18:D19,">0"))*0.02083333333

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[tj007]

Great!, both worked.