SUM Formula

[SantasLittleHelper]

This is probably a REALLY basic thing but I couldn't find anywhere with a solution which works...

Is it possible to SUM all of the numbers in Column C Where Column B (On the same line) equals X. (Example Below)

[TABLE="width: 500"]
<tbody>[TR]
[TD]Month[/TD]
[TD]Total[/TD]
[/TR]
[TR]
[TD]Jan 2018[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Jan 2018[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Feb 2018[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]Feb 2018[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Feb 2018[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]

So I need a field which will create a total of 9 for January and 12 for February. (There is usually approximately 10 rows per month of the year)

 

[steve the fish]

You can use a SUMIFS formula if you need a formula or you could use a pivot table.