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.
Bookmarks