That type of countif can be made using SUMPRODUCT instead. For example, if
you look for the value 3 in column A, and the value "sold" in column B, you
may use a formula like:
=SUMPRODUCT(--(A1:A1000=3),--(B1:B1000="sold"))
Change the ranges and values as appropiate.
Hope this helps,
Miguel.
"AndyBrown" wrote:
i have found the exact thing i want in excel 2007, but it's not in the
older 2003 version.
I have 2 columns, say A and B, if it is current in one and the other
says sold in it then i want that to increment once.
all i want is the totals of the amount that correspond.
Can any one help me please.
Andy
--
AndyBrown
------------------------------------------------------------------------
AndyBrown's Profile: http://www.excelforum.com/member.php...o&userid=36594
View this thread: http://www.excelforum.com/showthread...hreadid=563322