Hoping to get help with this formula....I need 2 conditions to be true
from 2 differnt columns, then I want to sum together in another column
all the numbers that meet the 2 criteria, currently I have it that it
counts the number of times that criteria is true, i need it to sum the
numbers together...as an example

_A,_B,_C_
1220.50, -, 5
1220.50, -, 10
1220.50, +, 2

if a =g5(1220.50) and B="-" then sum C. my formula gives me 2 which is
the count, i am looking for the SUM, it should give me 15...thanks.


--
MaxTomas
------------------------------------------------------------------------
MaxTomas's Profile: http://www.excelforum.com/member.php...o&userid=24683
View this thread: http://www.excelforum.com/showthread...hreadid=382578