Hello. I'd appreciate a nudge in the right direction with this issue, as I've
been searching but I can't seem to solve this on my own.

I'm trying to create a formula that goes through a list of data, and
subtotals (sum) all entries only if columns A, B and C each equal a
particular text string. Each string is different. Column E is where it needs
to sum the totals from.

This is a sample of sheet A (raw data).

Market Type Job Total
Australia AA Pink Car AA 295
Australia AA Pink Car AA 99
Australia RR Pink Car RR 30
Australia AA AUS Test GPC AA 1357
Australia RR AUS Test RR 3
Australia AA Pink Car AA 99
Australia AA Pink Car AA 99
Australia ZZ AUS Test BB / ZZ 456
India ZZ India ZZ Cat 3
India ZZ India ZZ Mouse 9
India AA India Calcium AA 200



I've created a Sheet that has a table with the criteria, waiting for the
totals to be entered:

Australia AA Pink Car AA (formula).


I've tried playing around with SUMIF, and SUBTOTAL, tried nesting a
combination of IF and AND statements, but it's becoming apparent to me that I
have no idea of what I'm doing.

Any help would be much appreciated.

Thanks.

- Cristian.