Sumifs when starting with a number

[cmacnab]

Hi, I'm trying to sum a lot of data based on date (over 7,000 lines) and based on a number and having problems. Dates in column A, amounts in column B and type in column 3. The type can vary but starts with the same number. How can I sum these? Please note, 3 and 30 are not the same thing so can't be summed together however the others can be summed by 4 or 5 as they are the same. Thanks in advance.

07/01/2018	13.00	41
07/01/2018	14.00	40
07/01/2018	15.00	43
07/01/2018	16.00	50
07/01/2018	17.00	56
07/01/2018	18.00	30
07/01/2018	19.00	3
07/02/2018	20.00	3
07/02/2018	21.00	41
07/02/2018	22.00	5
07/02/2018	23.00	56
07/02/2018	24.00	42
07/02/2018	25.00	40
07/02/2018	26.00	30

<tbody>
</tbody>

 

[shg]

Pivot table?

	H​	I​	J​	K​	L​	M​	N​	O​	P​	Q​	R​
1​	Sum of Amt	Column Labels
2​	Row Labels	3​	5​	30​	40​	41​	42​	43​	50​	56​	Grand Total
3​	7/1/2018	19​		18​	14​	13​		15​	16​	17​	112​
4​	7/2/2018	20​	22​	26​	25​	21​	24​			23​	161​
5​	Grand Total	39​	22​	44​	39​	34​	24​	15​	16​	40​	273​

 

[cmacnab]

No, too complicated for what I need. I need a summary of deposits by date and type for a month. I've done it before but I can't remember how.

 

[cmacnab]

..

 

[shg]

	A​	B​	C​	D​	E​	F​	G​
1​	Date​	Amt​	Type​	​	Type​	Amt​
2​	7/1/2018​	13​	41​		3​	39​	F2: =SUMIF($C$2:$C$15, E2, $B$2:$B$15)
3​	7/1/2018​	14​	40​		5​	22​
4​	7/1/2018​	15​	43​		30​	44​
5​	7/1/2018​	16​	50​		40​	39​
6​	7/1/2018​	17​	56​		41​	34​
7​	7/1/2018​	18​	30​		42​	24​
8​	7/1/2018​	19​	3​		43​	15​
9​	7/2/2018​	20​	3​		50​	16​
10​	7/2/2018​	21​	41​		56​	40​
11​	7/2/2018​	22​	5​
12​	7/2/2018​	23​	56​
13​	7/2/2018​	24​	42​
14​	7/2/2018​	25​	40​
15​	7/2/2018​	26​	30​

 

[cmacnab]

	A​	B​	C​	D​	E​	F​	G​
1​	Date​	Amt​	Type​		Type​	Amt​
2​	7/1/2018​	13​	41​		3​	39​	F2: =SUMIF($C$2:$C$15, E2, $B$2:$B$15)
3​	7/1/2018​	14​	40​		5​	22​
4​	7/1/2018​	15​	43​		30​	44​
5​	7/1/2018​	16​	50​		40​	39​
6​	7/1/2018​	17​	56​		41​	34​
7​	7/1/2018​	18​	30​		42​	24​
8​	7/1/2018​	19​	3​		43​	15​
9​	7/2/2018​	20​	3​		50​	16​
10​	7/2/2018​	21​	41​		56​	40​
11​	7/2/2018​	22​	5​
12​	7/2/2018​	23​	56​
13​	7/2/2018​	24​	42​
14​	7/2/2018​	25​	40​
15​	7/2/2018​	26​	30​

<tbody>
</tbody>

That would only work for that line. I need a sum for several numbers together. For example, lines 5, 6, 7 & 8 would all be summed together to equal 112.00

 

[shg]

Done guessing. Please provide an example with desired results.