Hello,
I have a countif formula based on 3 different criteria but now I want to add in a 4th criteria and that is a date. The picture example below that I have columns B-E is the data and I want to fill in the chart for columns G-P. This is going to be an ongoing and daily sum, I will have to at the end of the day hard code the information with a copy past values. I thought about doing a countif with "today" in the formula but I don't want the data to duplicate, as you can see in the example there is a total column.
=IF(COUNTIFS($C$8:$C$13,"Banana",$D$8:$D$13,"Incoming",$E$8:$E$13,"Y")=0,"",COUNTIFS($C$8:$C$13,"Banana",$D$8:$D$13,"Incoming",$E$8:$E$13,"Y")) this is the formula I have in cell H8 currently.
I have a countif formula based on 3 different criteria but now I want to add in a 4th criteria and that is a date. The picture example below that I have columns B-E is the data and I want to fill in the chart for columns G-P. This is going to be an ongoing and daily sum, I will have to at the end of the day hard code the information with a copy past values. I thought about doing a countif with "today" in the formula but I don't want the data to duplicate, as you can see in the example there is a total column.
=IF(COUNTIFS($C$8:$C$13,"Banana",$D$8:$D$13,"Incoming",$E$8:$E$13,"Y")=0,"",COUNTIFS($C$8:$C$13,"Banana",$D$8:$D$13,"Incoming",$E$8:$E$13,"Y")) this is the formula I have in cell H8 currently.