Using the first row in this example

=SUMPRODUCT(--(MOD(COLUMN(1:1),2)=1),--(1:10))

of course if you don't want text to be included

=SUMPRODUCT(--(MOD(COLUMN(1:1),2)=1),--(ISNUMBER(1:1)),--(1:10))


I assumed the numbers cannot be negative


--
Regards,

Peo Sjoblom



"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.