sumif function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sulasno - 17 Oct 2007 14:17 GMT

is it possible to use 2 criterias?
tia

Reply to this Message

Mike H - 17 Oct 2007 14:24 GMT

Have a look at JW's site

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

Mike

> is it possible to use 2 criterias?
> tia

Reply to this Message

Sandy Mann - 17 Oct 2007 14:30 GMT

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

Signature

HTH

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

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

> is it possible to use 2 criterias?
> tia

Reply to this Message

Bernard Liengme - 17 Oct 2007 17:20 GMT

For details on SUMPRODUCT see
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
http://mcgimpsey.com/excel/formulae/doubleneg.html

Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

> is it possible to use 2 criterias?
> tia

Reply to this Message

Sulasno - 19 Oct 2007 02:11 GMT

thanks to everyone for the links

> is it possible to use 2 criterias?
> tia

Reply to this Message