About Us

tested and worked fine.

--
Don Guillett
SalesAid Software

"Don Guillett" wrote in message
...
try this idea

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

--
Don Guillett
SalesAid Software

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Changing a range of an array in a SUMPRODUCT formula gives a #N/A error	Chrism	Excel Discussion (Misc queries)	4	May 4th 05 04:06 PM
sumproduct of part cells of a range with blanks	excelFan	Excel Discussion (Misc queries)	4	February 25th 05 10:37 PM
Indirect range in SUMPRODUCT?	BobT	Excel Discussion (Misc queries)	2	February 16th 05 08:51 PM
SUMPRODUCT with date range question	Rob V	Excel Discussion (Misc queries)	1	January 31st 05 03:55 PM
using sumproduct in a range of text fields?	Basil	Excel Worksheet Functions	1	December 13th 04 12:19 PM

Menu

About Us