I am trying to get a formula that will return a value based on two criteria from a different sheet.
I have tried array's, I have tried if/and, I am at a loss. Any help would be greatly appreciated.
Column1 Column2 Column3
MOM ---- 1 ---- 10
MOM ---- 2 ---- 15
DAD ---- 3 ---- 20
SON ---- 2 ---- 25
DGHT ---- 5 ---- 30
SON ---- 9 ---- 35
DAD ---- 3 ---- 40
All of this info is pasted on a sheet labeled "1"
on my other sheet (same workbook)
I would like to sum everything in column3 that is labeled DAD in column1 that is also >2 in column2
So in this case it would give me 60
Let me know if this is not clear. Thanks in advance for any help
Bookmarks