CountIfS not working as expected

Hi,

I am hoping someone can shed some light on what I am doing wrong within this formula. I am also trying to add aging 0-1day, 2-5 day, 6-10 day and over 10.

I am using this formula to count:
=COUNTIFS(general_report!O2:O281,"<=1",general_report!A1:A281,"=Incident", general_report!F1:F281,"=P1")

When I use this formula I receive an error #VALUE! however if I break it up I the results are correct meaning.
=COUNTIFS(general_report!O2:O281,"<=1",general_report!A1:A281,"=Incident") THIS WORKS

=COUNTIFS(general_report!F1:F281,"=P1") THIS WORKS

=COUNTIFS(general_report!O2:O281,"<=1",general_report!A1:A281,"=Incident", general_report!F1:F281,"=P1") THIS DOESN'T work. :/

On a side note I am trying to figure out how to report on age the "Day's Open" if anyone can give me any tips in this area I would be very, very happy.

Thanks,

Ruth S.

This formula contains an error ... =COUNTIFS(general_report!O2:O281,"<=1",general_report!A1:A281,"=Incident", general_report!F1:F281,"=P1")

The three ranges you listed are NOT the same size. The "O" column is one row shorter than the "A" or "F" Column ... change "O2:O281" to "O1:O281"

Well see below this when I filter on the same criteria they do exist see below. That was the first thing I checked because early on I added "New", "Open" from a single filed and 0 records returned and :/ CountIFS looks for all criteria to return so I removed it. That isn't the case here and I can not figure out what I did wrong.
Incident-1.JPG

OMG! and I have been sitting here for about 2 hours trying to figure out what it was I was doing wrong and trying a bunch of different things.

Any idea on how I can add aging? I need to be able to take "days open" and then how many of those cases fall into 0-1day, 2-5 day, 6-10 day and over 10 (aging). Then I have to figure out the percentage based on the total cases of that type.

Thanks again for your help!