How to sum if columns have unique data.

[Excelever]

Hello ever one.

I have the below table , I was trying to sum the values in column E2 (Total COUNT) FOR matching data in column A2 and B2 ( NAME1 / NAME 2 ) and matching data in column C2 ( TYPE ).

Thank you.

( below is a sample sheet )

NAME1	NAME2	TYPE	Month	Total COUNT	COST
JOHN	HISE	110	Jan-17	22	40.3
JOHN	HISE	110	Feb-17	20	40.3
PHILIP	ROY	11N	Mar-17	22	43.3
MIKE	HON	12W	Jan-17	48	48.0
MIKE	HON	34X	Feb-17	44	44.0
ALBERT	KING	33V	Mar-17	49	49.0

<tbody>
</tbody>

 

[Aladin Akyurek]

Do you also have a desired sum you would want to communicate as a guidance in search of an appropriate formula?

 

[Excelever]

Do you also have a desired sum you would want to communicate as a guidance in search of an appropriate formula?

Not really.
Thank you.

 

[Aladin Akyurek]

Not really.
Thank you.

You mean you don't know what the result should be for the sample you posted?

 

[snjpverma]

Hello ever one.

I have the below table , I was trying to sum the values in column E2 (Total COUNT) FOR matching data in column A2 and B2 ( NAME1 / NAME 2 ) and matching data in column C2 ( TYPE ).

Thank you.

( below is a sample sheet )

NAME1	NAME2	TYPE	Month	Total COUNT	COST
JOHN	HISE	110	Jan-17	22	40.3
JOHN	HISE	110	Feb-17	20	40.3
PHILIP	ROY	11N	Mar-17	22	43.3
MIKE	HON	12W	Jan-17	48	48.0
MIKE	HON	34X	Feb-17	44	44.0
ALBERT	KING	33V	Mar-17	49	49.0

<tbody>
</tbody>

How did you get the Total count as 22 and 20 in your data when your Nane1/Name2 and Type all are same ?

NAME1	NAME2	TYPE	Month	Total COUNT	COST
JOHN	HISE	110	Jan-17	22	40.3
JOHN	HISE	110	Feb-17	20	40.3

<tbody>
</tbody>

 

[Excelever]

You mean you don't know what the result should be for the sample you posted?

Sorry, I know what the results will be:-

For example for JOHN HISE , if the TYPE is 110 , then the total count will be 42 .

 

[Excelever]

Sorry, I know what the results will be:-

For example for JOHN HISE , if the TYPE is 110 , then the total count will be 42 .

The Total count comes ready from the source, no formula.

 

[Excelever]

The Total count comes ready from the source, no formula.

The counts are for different months of the year.

 

[snjpverma]

The Total count comes ready from the source, no formula.

Try the below formula

Excel Workbook
	A	B	C	D
10	NAME1	NAME2	TYPE	Sum of Total count
11	JOHN	HISE	110	42
12	PHILIP	ROY	11N	22
13	MIKE	HON	12W	48
14	MIKE	HON	34X	44
15	ALBERT	KING	33V	49
Sheet1

 

[Aladin Akyurek]

Sorry, I know what the results will be:-

For example for JOHN HISE , if the TYPE is 110 , then the total count will be 42 .

NAME1	NAME2	TYPE	Month	Total COUNT	COST			john
JOHN	HISE	110	17-Jan	22	40.3			hise
JOHN	HISE	110	17-Feb	20	40.3			110
PHILIP	ROY	11N	17-Mar	22	43.3
MIKE	HON	12W	17-Jan	48	48			42
MIKE	HON	34X	17-Feb	44	44
ALBERT	KING	33V	17-Mar	49	49

<tbody>
</tbody>

In I5 just enter:

=SUMIFS(E:E,A:A,I1,B:B,I2)

Is this what you are looking for?