To countifs or not to countifs

[tammy01977]

This is the information. We are wanting to create another sheet that will add up all the coat, blast, and cutout for a certain date. I only know a little bit about the formulas and all the websites say to use this formula countifs. I am clueless as how to use it, especially since I have 4 columns to get the information from.


[TABLE="width: 524"]
<colgroup><col span="4"></colgroup><tbody>[TR]
[TD]POD DATE[/TD]
[TD]COAT[/TD]
[TD]BLAST[/TD]
[TD]CUTOUT[/TD]
[/TR]
[TR]
[TD]2/15/2019[/TD]
[TD]0.00[/TD]
[TD]2321.00[/TD]
[TD]3373.00[/TD]
[/TR]
[TR]
[TD]2/22/2019[/TD]
[TD]5471.00[/TD]
[TD]2321.00[/TD]
[TD]0.00[/TD]
[/TR]
[TR]
[TD]3/1/2019[/TD]
[TD]0.00[/TD]
[TD]2321.00[/TD]
[TD]3373.00[/TD]
[/TR]
[TR]
[TD]2/15/2019[/TD]
[TD]0.00[/TD]
[TD]2321.00[/TD]
[TD]3373.00[/TD]
[/TR]
[TR]
[TD]3/15/2019[/TD]
[TD]0.00[/TD]
[TD]2321.00[/TD]
[TD]3373.00[/TD]
[/TR]
[TR]
[TD]3/22/2019[/TD]
[TD]0.00[/TD]
[TD]2321.00[/TD]
[TD]3373.00[/TD]
[/TR]
[TR]
[TD]2/15/2019[/TD]
[TD]0.00[/TD]
[TD]2321.00[/TD]
[TD]3373.00[/TD]
[/TR]
[TR]
[TD]2/22/2019[/TD]
[TD]0.00[/TD]
[TD]2321.00[/TD]
[TD]3373.00[/TD]
[/TR]
</tbody>[/TABLE]



[TABLE="width: 524"]
<colgroup><col span="4"></colgroup><tbody>[TR]
[TD]POD DATE[/TD]
[TD]COAT[/TD]
[TD]BLAST[/TD]
[TD]CUTOUT[/TD]
[/TR]
[TR]
[TD]2/15/2019[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]2/22/2019[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3/1/2019[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3/8/2019[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3/15/2019[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3/22/2019[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3/29/2019[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]4/5/2019[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

 

[tammy01977]

I see what I was doing wrong, I was selecting all 3 columns and not just the one for the second section of the formula. Thank you so much, . I have so much to learn about excel. Need to start taking college classes for it all.

 

[jtakw]

You're welcome.