Countifs / Sumifs query

[gmazza76]

Good Afternoon,

I am trying to do a sumif or countif based on a date range.
I can get the countif section to work with no issues when I remove the red txt section.
I am trying to get column E to add together anything with "E" + "DF" togther based on the date in column B, Active in Column D and so on

=COUNTIFS($B$15:$B$3000,"="&TODAY(),$D$15:$D$3000,"Active",$E$15:$E$3000,"E",$E$15:$E$3000,"DF",$F$15:$F$3000,"Yes",$G$15:$G$3000,"Yes")

All help appreciated
Thanks

 

[Jonmo1]

Countifs is an AND criteria...

It's only going to count rows where both of those criteria are TRUE..

So for example, Assuming all other criteria are true,
Row 15 will only be counted if the value in E15 = "E" AND the value in E15 = "DF"
This of coarse is not possible.

I believe what you want to say is
Row 15 will be counted if the value in E15 = "E" OR the value in E15 = "DF"

Try
=SUM(COUNTIFS($B$15:$B$3000,"="&TODAY(),$D$15:$D$3000,"Active",$E$15:$E$3000,{"E","DF"},$F$15:$F$3000,"Yes",$G$15:$G$3000,"Yes"))

 

[gmazza76]

Many thanks that was exactly what I was looking for

Countifs is an AND criteria...

It's only going to count rows where both of those criteria are TRUE..

So for example, Assuming all other criteria are true,
Row 15 will only be counted if the value in E15 = "E" AND the value in E15 = "DF"
This of coarse is not possible.

I believe what you want to say is
Row 15 will be counted if the value in E15 = "E" OR the value in E15 = "DF"

Try
=SUM(COUNTIFS($B$15:$B$3000,"="&TODAY(),$D$15:$D$3000,"Active",$E$15:$E$3000,{"E","DF"},$F$15:$F$3000,"Yes",$G$15:$G$3000,"Yes"))

 

[Jonmo1]

You're welcome.