DATA SECTION:
So I have data in one sheet like this:
TYPE AMOUNT YES/NO
Pig 20 Y
Pig 30 N
Pig 10 Y
Cow 20 Y
Cow 30 N
Cow 50 N
Bat 10 N
RESULT SECTION
I'm using Google Spreadsheets and have a table in another sheet. I would like to have a formula (placed in the cells like the one labeled [=?]) that gives me sums like thus:
TYPE YES NO
Bat [=?] [=?]
Cow 20 80
Pig 30 30
But I still need the formula.
PROBLEM SECTION
I'm struggling. I want a formula in the results table that looks up in the data section for a match in type and SUMs the Ys for that type. I would like another formula that looks up in the data section for a match in type and SUMs the Ns for that type. I assume VLOOKUP or HLOOKUP, but I'm struggling getting the SUM in addition. I linked an example sheet here.
ADDITIONAL EDITS AFTER THE POST
I don't need a query. I just need a formula that replaces the [=?] for each column in the result section. I just put a ton of info there as an example.