Multiple COUNTIFS formulas in one cell is not working.

Hi guys,

I've created a formula to find out how many bugs were logged in a system at a given date, the data in question is in a pivot table in a separate sheet.

The COUNTIFS formulas work perfectly ok independently, however, when I combine them to match a new set of criteria, the first formula appears to be disregarded.

This is the solution:

=COUNTIFS(Pivot_Data[Created Date],">"&DATEVALUE("07/10/2017"),Pivot_Data[Created Date],"<"&(DATEVALUE("07/10/2017")+1))+COUNTIFS(Pivot_Data[State],"Active",Pivot_Data[Severity],"*1*")+COUNTIFS(Pivot_Data[State],"Proposed",Pivot_Data[Severity],"*1*")

I would attach the workbook, but I am at work and unable to do so.

I've searched everywhere online and I can't find anything that remotely represents this situation.

If anyone could help or point me in the right direction it would be greatly appreciated.

Thanks

Try this:

Please Login or Register  to view this content.

Jonmo1's solution works perfectly, thank you very much for your assistance! I never knew COUNTIFS could be used like this.. so much more simpler! Thanks again