The SUMPRODUCT function will work within my spreadsheet, however, it is
limited to the fact you have to specify row numbers.
With the SUMIF function you can specify as an example ... SUMIF(A:A etc ...
ie- you do not have to specify over which rows you want the sum function to
work.
I tried this way with SUMPRODUCT but the only answer that was returned was
.... #NUM!
Is it possible to use the row = A:A statement instead of specifying row
numbers?

"Bernard Liengme" wrote:

SUMIF works only with 1 condition; for more you need SUMPRODUCT.
You have given us little to work with so here is a general reference
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
Come back if you have more questions
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Bobito" wrote in message
...
I am trying to "sum" a column using "sumif" ... but need to use 2 criteria.
I have tried the Sumif(And(< cond 1 , cond 2 )(ans) but this does not
work.
Has anybody any idea how write the correct statement