Help with multiconditional sumif with range
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 |
All times are GMT +1. The time now is 10:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com