Count Ifs that includes a date

[wangaa11]

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.

 

[etaf]

do you only want to fill if the date are equal

=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",$B$8:$B$13, "H$7))

so for banana - 15th is 0 , 16th is 2 and 17th is 1 - BUT as incoming is Y
OR you could just add them all in 1 formula

 

[wangaa11]

do you only want to fill if the date are equal

=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",$B$8:$B$13, "H$7))

so for banana - 15th is 0 , 16th is 2 and 17th is 1 - BUT as incoming is Y
OR you could just add them all in 1 formula

It has to include the date in the example all would be 0 except for Feb 16th which would be 1. It has to be incoming and a Y for yes, does that make more sense now? Thank you for the help.

 

[etaf]

thats what the formula should do
1 for 16th
But your showing a 1 under the 15th ?

 

[wangaa11]

thats what the formula should do
1 for 16th
But your showing a 1 under the 15th ?

That was just the initial formula I was using before I needed to add in the date. It can be disregarded completely just wanted to provide an idea of the formula I was initially using.

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1
2
3
4
5
6
7								15/02/2021	16/02/2021	17/02/2021	18/02/2021	19/02/2021	20/02/2021	21/02/2021	22/02/2021
8		16/02/2021	Banana	Incoming	Y		Banana		1
9		16/02/2021	Banana	Incoming	N		Strawberry
10		16/02/2021	Apple	Outgoing	Y		Apple
11		17/02/2021	Banana	Incoming	N
12		18/02/2021	Strawberry	Incoming	N
13		19/02/2021	Apple	Outgoing	N
14
15
Main

Cell Formulas
Range	Formula
H8:O10	H8	=IFERROR(1/(1/COUNTIFS($C$8:$C$13,$G8,$D$8:$D$13,"Incoming",$E$8:$E$13,"Y",$B$8:$B$13, H$7)),"")

 

[etaf]

edit

However, you have another solution now

 

[wangaa11]

Thank you both for the help.

 

[Fluff]

Glad we could help & thanks for the feedback.