SUMIF with double conditional

[Growlithe]

Hey everybody,

I've been racking my brain around this for a few hours now and just cant seem to come up with the answer, was hoping someone here may have a better idea than me.

Essentially, I have a database where I need to SUM a range IF the criteria in two cells of two columns are met, however these are variable.

Example below:

A

B

C

D

E

F

G

<tbody>
</tbody>

First name	Last Name	Irrelevant	Individual Value	Irrelevant	Irrelevant	Irrelevant details
ABCD	WZYZ	918	1275	date here	date here	Details 12345678910
ABCD	WZYZ	2090	7434	date here	date here	Details 12345678910
ABCD	WZYZ	1982	14440	date here	date here	Details 12345678910
ERTY	KJHG	2458	10017	date here	date here	Details 12345678910
ERTY	KJHG	1691	6622	date here	date here	Details 12345678910
ERTY	KJHG	479	13841	date here	date here	Details 12345678910
VBNK	FGHJ	355	13947	date here	date here	Details 12345678910
VBNK	FGHJ	1245	6083	date here	date here	Details 12345678910
VBNK	FGHJ	1877	14466	date here	date here	Details 12345678910
VBNK	FGHJ	2150	1476	date here	date here	Details 12345678910
VBNK	FGHJ	1498	1024	date here	date here	Details 12345678910
VBNK	FGHJ	2931	15999	date here	date here	Details 12345678910
VBNK	FGHJ	2613	1091	date here	date here	Details 12345678910
VBNK	FGHJ	246	10351	date here	date here	Details 12345678910
VBNK	FGHJ	1857	3900	date here	date here	Details 12345678910
ERTYU	THJM	900	5565	date here	date here	Details 12345678910
ERTYU	THJM	1754	12680	date here	date here	Details 12345678910
ERTYU	THJM	302	8749	date here	date here	Details 12345678910
ERTYU	THJM	2262	1590	date here	date here	Details 12345678910
ERTYU	THJM	2237	13887	date here	date here	Details 12345678910
ERTYU	THJM	1533	14075	date here	date here	Details 12345678910
ERTYU	THJM	2378	1904	date here	date here	Details 12345678910

<tbody>
</tbody>

So, essentially, I need to SUM G each time the corresponding A and or B changes value.
So here Id SUM G2:4 and then 6:8 etc...
Just to make things that bit more difficult the first and last names here will pop up again in random combinations with each and others further down the list.

 

[FDibbins]

G doesn't actually contain "summable" data, so I assumed that was dummy/sample data?

Try this, it will create a running total by name...
H2=IF(A2="","",SUMIFS($G$2:G2,$A$2:A2,A2,$B$2:B2,B2))
copied down