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