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.

POD DATE	COAT	BLAST	CUTOUT
2/15/2019	0.00	2321.00	3373.00
2/22/2019	5471.00	2321.00	0.00
3/1/2019	0.00	2321.00	3373.00
2/15/2019	0.00	2321.00	3373.00
3/15/2019	0.00	2321.00	3373.00
3/22/2019	0.00	2321.00	3373.00
2/15/2019	0.00	2321.00	3373.00
2/22/2019	0.00	2321.00	3373.00

<colgroup><col span="4"></colgroup><tbody>
</tbody>

POD DATE	COAT	BLAST	CUTOUT
2/15/2019
2/22/2019
3/1/2019
3/8/2019
3/15/2019
3/22/2019
3/29/2019
4/5/2019

<colgroup><col span="4"></colgroup><tbody>
</tbody>

 

[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.