Forum Discussion
Solved
Countifs Help
Hello all. Thank you in advance. This may be a duplicate post, I just cannot find the original. I am trying to use the COUNTIFS to get data from basically two or three columns. The Date colu...
- Mark, Thank You very much!!! I will have to read up on those 3. It is confusing in that you are not need to call out the part type or the material. Again, Thank you
=SUMIF($C$2:$C$11,B14,$D$2:$D$11)If Material is the only criteria you can use this formula for the data layout of the example.
=SUMPRODUCT(($A14=$C$2:$C$11)*(B$13=$B$2:$B$11)*$D$2:$D$11)For 2 criteria you can apply SUMPRODUCT.
=SUMIFS($D$2:$D$11,$A$2:$A$11,F2,$B$2:$B$11,G2,$C$2:$C$11,H2)For all 3 criteria you can make a unique list of Delivery Date, Parts and Material and then use SUMIFS.
Mark, Thank You very much!!! I will have to read up on those 3. It is confusing in that you are not need to call out the part type or the material. Again, Thank you