=SUMPRODUCT(--(MOD(COLUMN(A2:M2),2)=1),--(A2:M20))

just change A2:M2 to your actual columns. I have also assumed you don't want
to count any negatives, hence 0

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Mechelle" wrote in message
...
I want to count if there are entries in every other column excluding zeros.

i.e.
A B C D
Paid Reserve Paid Reserve
0 10,000 500 0

I want a count (not sum) of those fields in colum A and C only, and if "0"
is the entry, I don't want to count it.

So in the example above, the result should be 1.

"Toppers" wrote:

Can you give an example of what you want? Do you mean COUNT or SUM?

"Mechelle" wrote:

I have a spreadsheet with a lot of columns. However, I want to only
count
data in every other column. Help please.