Ira Hopkins
New Member
- Joined
- Apr 8, 2019
- Messages
- 25
Hoping someone can help. I am trying to match a name Column A for payments between 2 date ( Quarters- ie January 1st 2019- March 31st 2019) If the criteria match I need to know how many claims and the total payment for claims for that person in the quarter- There is generally more than one claim for that person in the quarter
I have tried =SUMIFS(DOWNLOAD!F:F,DOWNLOAD!A:A,A223,DOWNLOAD!D:D,"<=1/4/2019") but when I add another date it will not work
Really hoping someone can help
[TABLE="width: 503"]
<colgroup><col span="5"><col><col></colgroup><tbody>[TR]
[TD]name[/TD]
[TD]Loc[/TD]
[TD]Practice[/TD]
[TD]No of Claims[/TD]
[TD] £ [/TD]
[TD]Payment Date[/TD]
[TD]Total[/TD]
[/TR]
[TR]
[TD]john[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]31-Jan-19[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]dave[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]31-Jan-18[/TD]
[TD="align: right"]29.4[/TD]
[/TR]
[TR]
[TD]brian[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]31-Jan-17[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]tom[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]31-Jan-16[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]george[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]01-Feb-18[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]tom[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]31-Jan-18[/TD]
[TD="align: right"]39.2[/TD]
[/TR]
[TR]
[TD]george[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]28-Feb-18[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]dave[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]28-Feb-18[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]colin[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]01-Mar-18[/TD]
[TD="align: right"]19.6[/TD]
[/TR]
[TR]
[TD]bob[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]02-Mar-18[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]john[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]28-Feb-18[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]dave[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]28-Feb-19[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]brian[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]01-Mar-19[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]peter[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]02-Mar-19[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]tom[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]28-Feb-18[/TD]
[TD="align: right"]19.6[/TD]
[/TR]
[TR]
[TD]george[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]28-Feb-17[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]tom[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]01-Mar-17[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]george[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]28-Jun-18[/TD]
[TD="align: right"]19.6[/TD]
[/TR]
[TR]
[TD]john[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]29-Jun-18[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]dave[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]30-Jun-18[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]brian[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]28-Feb-18[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]colin[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]28-May-18[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]colin[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]28-Feb-16[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]brian[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]28-Feb-16[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]kyle[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]29-Feb-16[/TD]
[TD="align: right"]19.6[/TD]
[/TR]
[TR]
[TD]kyle[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD] 9.80 [/TD]
[TD="align: right"]01-Mar-16[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]tom[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD] 9.80 [/TD]
[TD="align: right"]31-May-18[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]george[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD] 9.80 [/TD]
[TD="align: right"]31-May-18[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]tom[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD] 9.80 [/TD]
[TD="align: right"]31-May-17[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]george[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]2[/TD]
[TD] 9.80 [/TD]
[TD="align: right"]31-May-18[/TD]
[TD="align: right"]19.6[/TD]
[/TR]
[TR]
[TD]john[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD] 9.80 [/TD]
[TD="align: right"]31-May-18[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]dave[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD] 9.80 [/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]brian[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD] 9.80 [/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]colin[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]2[/TD]
[TD] 10.03 [/TD]
[TD="align: right"]31-Aug-18[/TD]
[TD="align: right"]20.06[/TD]
[/TR]
[TR]
[TD]colin[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD] 10.03 [/TD]
[TD="align: right"]31-Aug-18[/TD]
[TD="align: right"]10.03[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]46[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]451.49[/TD]
[/TR]
</tbody>[/TABLE]
I have tried =SUMIFS(DOWNLOAD!F:F,DOWNLOAD!A:A,A223,DOWNLOAD!D:D,"<=1/4/2019") but when I add another date it will not work
Really hoping someone can help
[TABLE="width: 503"]
<colgroup><col span="5"><col><col></colgroup><tbody>[TR]
[TD]name[/TD]
[TD]Loc[/TD]
[TD]Practice[/TD]
[TD]No of Claims[/TD]
[TD] £ [/TD]
[TD]Payment Date[/TD]
[TD]Total[/TD]
[/TR]
[TR]
[TD]john[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]31-Jan-19[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]dave[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]31-Jan-18[/TD]
[TD="align: right"]29.4[/TD]
[/TR]
[TR]
[TD]brian[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]31-Jan-17[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]tom[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]31-Jan-16[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]george[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]01-Feb-18[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]tom[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]31-Jan-18[/TD]
[TD="align: right"]39.2[/TD]
[/TR]
[TR]
[TD]george[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]28-Feb-18[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]dave[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]28-Feb-18[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]colin[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]01-Mar-18[/TD]
[TD="align: right"]19.6[/TD]
[/TR]
[TR]
[TD]bob[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]02-Mar-18[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]john[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]28-Feb-18[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]dave[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]28-Feb-19[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]brian[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]01-Mar-19[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]peter[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]02-Mar-19[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]tom[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]28-Feb-18[/TD]
[TD="align: right"]19.6[/TD]
[/TR]
[TR]
[TD]george[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]28-Feb-17[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]tom[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]01-Mar-17[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]george[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]28-Jun-18[/TD]
[TD="align: right"]19.6[/TD]
[/TR]
[TR]
[TD]john[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]29-Jun-18[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]dave[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]30-Jun-18[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]brian[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]28-Feb-18[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]colin[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]28-May-18[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]colin[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]28-Feb-16[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]brian[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]28-Feb-16[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]kyle[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]29-Feb-16[/TD]
[TD="align: right"]19.6[/TD]
[/TR]
[TR]
[TD]kyle[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD] 9.80 [/TD]
[TD="align: right"]01-Mar-16[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]tom[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD] 9.80 [/TD]
[TD="align: right"]31-May-18[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]george[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD] 9.80 [/TD]
[TD="align: right"]31-May-18[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]tom[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD] 9.80 [/TD]
[TD="align: right"]31-May-17[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]george[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]2[/TD]
[TD] 9.80 [/TD]
[TD="align: right"]31-May-18[/TD]
[TD="align: right"]19.6[/TD]
[/TR]
[TR]
[TD]john[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD] 9.80 [/TD]
[TD="align: right"]31-May-18[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]dave[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD] 9.80 [/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]brian[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD] 9.80 [/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD="align: right"]9.8[/TD]
[/TR]
[TR]
[TD]colin[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]2[/TD]
[TD] 10.03 [/TD]
[TD="align: right"]31-Aug-18[/TD]
[TD="align: right"]20.06[/TD]
[/TR]
[TR]
[TD]colin[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]56987[/TD]
[TD="align: right"]1[/TD]
[TD] 10.03 [/TD]
[TD="align: right"]31-Aug-18[/TD]
[TD="align: right"]10.03[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]46[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]451.49[/TD]
[/TR]
</tbody>[/TABLE]