simple vlookup

[blademaster]

A B C D

[TABLE="width: 343"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][TABLE="width: 343"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Issue Date[/TD]
[TD] Advertisement[/TD]
[TD]CMs[/TD]
[TD]Type[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
3 Feb 12 C
3 Feb 6 C
3 Feb 1 D

Hi
Iam trying to figure out how to create a sumif that would calculate the sum of column C but it must only calculate those for a specific issue date (column A) and specific type, whether C or D in column D

I would be grateful for any help

 

[Gerald Higgins]

Take a look at the SUMIFS function.

 

[blademaster]

Yes I understand that but I cannot get it working. Been varying =sumif(vlookup ... for example but cannot get it to total

 

[Joe4]

Why are you trying to use VLOOKUP at all?

Your formula should look something like (for the example you provided):
=

SUMIFS(C2:C4,A2:A4,DATE(2018,2,3),D2:D4,"C")

 

[blademaster]

WOW!

There are so many ways of achieving the answer, I was working on something like this =SUMIF(A$2:$A$500, H5, C$2:C$500) however your way has worked perfectly.

Thank you very much indeed

 

[Joe4]

You are welcome!