S
Sulasno
is it possible to use 2 criterias?
tia
tia
G
Guest
S
Sandy Mann
It depends on what you are doing.
=SUMIF(D1
11,">5")-SUMIF(D111,">10")
will sum all numbers from 5 to 10 in the range
=SUMPRODUCT((B1:B11="Sandy")*(C1:C11="Sulasno")*D111)
will sum every entry in D111 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
(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
=SUMIF(D1
11,">5")-SUMIF(D111,">10")will sum all numbers from 5 to 10 in the range
=SUMPRODUCT((B1:B11="Sandy")*(C1:C11="Sulasno")*D1
11)will sum every entry in D1
11 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
(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
B
Bernard Liengme
For details on SUMPRODUCT see
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
http://mcgimpsey.com/excel/formulae/doubleneg.html
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
http://mcgimpsey.com/excel/formulae/doubleneg.html
S
Sulasno
thanks to everyone for the links