Countifs and sumifs using Name Range

[anh03]

how do i make countifs and sumifs function/formula to count and sum everything on Name range.
sorry i want to attach my worksheet but dont know how first time.
any help or advise would be greatly appreciated

thank you

=COUNTIFS($A:$A,G3,$D:$D,Docs)

=SUMIFS($C:$C,$A:$A,Docs)

this is my name range
[TABLE="width: 195"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]name range[/TD]
[TD]Docs
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Ready for Docs[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Lenders Out-WET[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Docs Out-WET[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Docs Out-DRY[/TD]
[/TR]
</tbody>[/TABLE]



[TABLE="width: 928"]
<colgroup><col><col><col><col span="3"><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Rep[/TD]
[TD]Docs Date[/TD]
[TD] Amount
[/TD]
[TD]Status[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Andrew[/TD]
[TD="align: right"]4/7/2015[/TD]
[TD] $ 21.17
[/TD]
[TD]Ready for Docs[/TD]
[TD][/TD]
[TD][/TD]
[TD]Rep[/TD]
[TD]test count[/TD]
[TD] test total [/TD]
[TD]Actual count[/TD]
[TD] Actual total [/TD]
[/TR]
[TR]
[TD]Andrew[/TD]
[TD="align: right"]3/31/2015[/TD]
[TD] $ 21.67
[/TD]
[TD]Docs Back-DRY[/TD]
[TD][/TD]
[TD][/TD]
[TD]Andrew[/TD]
[TD="align: right"]0
[/TD]
[TD] $ -
[/TD]
[TD="align: right"]1[/TD]
[TD] $ 21.17[/TD]
[/TR]
[TR]
[TD]Andrew[/TD]
[TD="align: right"]4/2/2015[/TD]
[TD] $ 24.17
[/TD]
[TD]Docs Back-DRY[/TD]
[TD][/TD]
[TD][/TD]
[TD]Brian [/TD]
[TD="align: right"]0[/TD]
[TD] $ - [/TD]
[TD="align: right"]1[/TD]
[TD] $ 18.17[/TD]
[/TR]
[TR]
[TD]Andrew [/TD]
[TD="align: right"]4/1/2015[/TD]
[TD] $ 24.67
[/TD]
[TD]Docs Back-DRY[/TD]
[TD][/TD]
[TD][/TD]
[TD]Chuck [/TD]
[TD="align: right"]0[/TD]
[TD] $ - [/TD]
[TD="align: right"]1[/TD]
[TD] $ 15.67[/TD]
[/TR]
[TR]
[TD]Andrew [/TD]
[TD="align: right"]4/2/2015[/TD]
[TD] $ 25.67
[/TD]
[TD]Docs Back-DRY[/TD]
[TD][/TD]
[TD][/TD]
[TD]Craig [/TD]
[TD="align: right"]0[/TD]
[TD] $ - [/TD]
[TD="align: right"]1[/TD]
[TD] $ 16.17[/TD]
[/TR]
</tbody>[/TABLE]

 

[jumbledore]

u can upload your workbook using tinyupload.com

 

[anh03]

thank you so this is the link that i have for the attachment using tinyupload.com
TinyUpload.com - best file hosting solution, with no limits, totaly free