Thank you... that one worked
--
martinson portland


"T. Valko" wrote:

Use SUMPRODUCT:

=SUMPRODUCT((A1:A10="x")*B1:D10)

--
Biff
Microsoft Excel MVP


"martinson" wrote in message
...
The sum range in my formula includes 3 columns. My formula is working but
only picking up numbers from the first column. What am I doing wrong?
--
martinson portland