Trying to get totals of one column from another column

[Prayder]

I have a column called sort_type that has different values in it like x, o, ooo, and another column called BoardFootage. I am wanting to compute the total boardfootage based off the value in the sort_type column within a certain day. So for instance on 3/5/2019 I want to know total boardfootage for X and total boardfootage for O, and total boardfootage for OOO. I have provided example data of what to pull from. I sincerely appreciate any help at all. Thank you!


[TABLE="width: 500"]
<tbody>[TR]
[TD]t_stamp[/TD]
[TD]Sort_Type[/TD]
[TD]BoardFootage[/TD]
[/TR]
[TR]
[TD][TABLE="width: 111"]
<tbody>[TR]
[TD="class: xl65, width: 111"]3/5/2019 16:01[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 101"]
<tbody>[TR]
[TD="class: xl65, width: 101"]X[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 126"]
<tbody>[TR]
[TD="class: xl65, width: 126"]6[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 111"]
<tbody>[TR]
[TD="class: xl65, width: 111"]3/5/2019 6:50[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 101"]
<tbody>[TR]
[TD="class: xl65, width: 101"]O[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD] [TABLE="width: 126"]
<tbody>[TR]
[TD="class: xl65, width: 126"]10[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 111"]
<tbody>[TR]
[TD="class: xl65, width: 111"]3/5/2019 6:49[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 101"]
<tbody>[TR]
[TD="class: xl65, width: 101"]OOO[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 126"]
<tbody>[TR]
[TD="class: xl65, width: 126"]6[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 111"]
<tbody>[TR]
[TD="class: xl65, width: 111"]3/5/2019 22:03[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 101"]
<tbody>[TR]
[TD="class: xl65, width: 101"]O[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 101"]
<tbody>[TR]
[TD="class: xl65, width: 101"][TABLE="width: 126"]
<tbody>[TR]
[TD="class: xl65, width: 126"]8[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[mikerickson]

It sounds like SUMIFS would be the function to use.