One way

=SUMPRODUCT((A12:A24=W34)*(B12:BA240))

using excel built in method of (--(range=x),--(range=y)

will not work if the ranges have different sizes

--
Regards,

Peo Sjoblom

(No private emails please)


"Tat" wrote in message
...
I have 27 columns. The first column refers to a calendar year ie 2003,
2004.
There are multilple occurences of the same year in this column. The rest
of
the columns may or may not have numbers in the cells.

I would like to count the cells that do have numbers that correspond to
the
year selected.

I'm not too sure how to use the sumproduct function but this is the
formula
I created and doesn't work:
=SUMPRODUCT(--(A12:A24=W34),--(B12:BA240))

W34 indicates the year I would like the used cells counted.
Assistance is mighty appreciated.