making a formula that sums one column after matching variable cell contents in two other columns

[StJohn Hawkes]

difficult to explain, but probably simple to do, if only I knew how!
I have rows headed "Name", "Month" and "Time" I need excel to read the name in the "Name" column and sum all the entries in the "time" column where the name in the row has the same number in the "month" column and place the sum of time in the cell next to the last time entry. Time is listed in minutes but I would like the "Total to date" column to read in hours and minutes.

Name month task time total to date
smith J 2 ..... 35 35
jones B 1 ....... 50 50
Adams c 3 ....... 46 35
smith C 1 ....... 10 10
smith j 2 ....... 10 20
Jones B 1 ....... 25 75
Adams C 1 ........ 40 86

 

[StJohn Hawkes]

sorry-Data didn't go as expected: This is what I need to achieve, where the total column sums all the times for the ( respective names with the same visit number) in the final column

DATE	NAME	VISIT	TIME	TOTAL
01/03	SMITH J	1	30	30
02/03	SMITH B	1	30	30
03/03	JONES A	1	30	30
03/03	JONES B	2	30	30
03/03	SMITH J	1	30	60
04/04	SMITH J	2	30	30
05/04	SMITH J	1	30	90
05/04	JONES A	1	30	60
05/04	JONES A	2	30	30 HOW DO i DO THIS?

<tbody>
</tbody>

 

[jtakw]

Hi,

This will do what you described in Post #2 , your OP request is slightly different.

Book1
	A	B	C	D	E
1	DATE	NAME	VISIT	TIME	TOTAL
2	3-Jan	SMITH J	1	30	30
3	3-Feb	SMITH B	1	30	30
4	3-Mar	JONES A	1	30	30
5	3-Mar	JONES B	2	30	30
6	3-Mar	SMITH J	1	30	60
7	4-Apr	SMITH J	2	30	30
8	4-May	SMITH J	1	30	90
9	4-May	JONES A	1	30	60
10	4-May	JONES A	2	30	30
Sheet37

Cell Formulas
Range	Formula
E2	=SUMIFS(D$2:D2,B$2:B2,B2,C$2:C2,C2)

E2 formula copied down.