sumif function
 

is it possible to use 2 criterias?
tia

sumif function
 

Have a look at JW's site

http://www.j-walk.com/ss/excel/tips/tip74.htm

Mike

"Sulasno" wrote:

is it possible to use 2 criterias?
tia

sumif function
 

It depends on what you are doing.

=SUMIF(D1:D11,"5")-SUMIF(D1:D11,"10")

will sum all numbers from 5 to 10 in the range

=SUMPRODUCT((B1:B11="Sandy")*(C1:C11="Sulasno")*D1 :D11)

will sum every entry in D1:D11 where there is an entry in Column B of
"Sandy" and an enrty of "Sulasno" in Column C

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Sulasno" wrote in message
...
is it possible to use 2 criterias?
tia

sumif function
 

For details on SUMPRODUCT see
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
http://mcgimpsey.com/excel/formulae/doubleneg.html
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Sulasno" wrote in message
...
is it possible to use 2 criterias?
tia

sumif function
 

thanks to everyone for the links
"Sulasno" wrote in message
...
is it possible to use 2 criterias?
tia