eobrien
New Member
- Joined
- Apr 29, 2017
- Messages
- 27
- Office Version
- 365
- Platform
- Windows
I am trying to write a formula that would say if column A1:A9="100001-Partner administrative" and if column b1:b9=501105 and if column g1:g9=IUL, then give me whatever number is in column C. I tried a Sumif, a sumifs, and a if statment with multiple criteria and can't get it. So, I need a formula that looks for these 3 conditions and then gives me a result and/or the $ amount sitting in column C. Any help would be greatly appreciated. E