COUNTIFS Using two criteria

[denepoh]

[TABLE="width: 75"]
<colgroup><col></colgroup><tbody>[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I'm trying to add up the number of times a gift has been chosen on a certain week number. Here is the table of data I will be using the information from.

[TABLE="width: 227"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Gift[/TD]
[TD]Date[/TD]
[TD]Week[/TD]
[/TR]
[TR]
[TD]Holiday[/TD]
[TD]21/03/2017[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Spa[/TD]
[TD]22/03/2017[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Car[/TD]
[TD]23/03/2017[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Holiday[/TD]
[TD]29/03/2017[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Spa[/TD]
[TD]30/03/2017[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Car[/TD]
[TD]31/03/2017[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Holiday[/TD]
[TD]05/04/2017[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Spa[/TD]
[TD]06/04/2017[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Car[/TD]
[TD]07/04/2017[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]

This is the totals I need to lookup and count the separate gifts depending on which week they were booked.

[TABLE="width: 520"]
<colgroup><col span="5"></colgroup><tbody>[TR]
[TD]Week[/TD]
[TD]Holiday[/TD]
[TD]Spa[/TD]
[TD]Car[/TD]
[TD]Total[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]

TIA

 

[brharrii]

Is this what you are looking for?

=COUNTIFS(A2:A10,"Holiday", C2:C10,1)

If so you would just need to set the criteria for your ranges for each row and column of your presentation data.

 

[denepoh]

AMAZING! Thank you been scratching my head all day

 

[brharrii]

Glad it worked for you!