Hi
use SUMPRODUCT.
=SUMPRODUCT(--(A1:A100="Linda"),--(B1:B100="rental"))
See
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
Regards
Frank Kabel
Frankfurt, Germany
"LPrain" schrieb im Newsbeitrag
...
How do I create a countif formula for multiple
conditions? I have a spreadsheet with two
colums: "agents name" and "rental or sale". I want to
create a formula that will count if the agents name
= "Linda" in column 1 and "rental" in column 2.
Any ideas?