#value! or "o" error in countifs formula

[Amit Desai]

Hi,

I need to make MIS Report where I need to count following.


in my row data sheet I have column like "Created By" = Technician name , "Cat_SubCat" = types of call he has attended , "Logged time" = Date a call was attended , etc. I want to count based on these 3 criteria. i.e.
on date 1-2-20 how many calls by Technician for Category "Ads internal - 1st shift" . my formula is as follows

=COUNTIFS('RAW Data'!R3:R1895,C$3,'RAW Data'!J3:J1895,$A$4,'RAW Data'!H3:H1895,$B5)

instead of result it just shows "0" in all cell.

can any one help me on this?

Regards,
Amit Desai.

 

[jasonb75]

You probably need to make the Raw data ranges absolute (add $ symbols). I don't think that will cure the problem, but I suspect that it will be part of it.
We will need to see the raw data as well to be able to spot any anomalies, but even that might not be enough to identify the cause.

 

[Amit Desai]

You probably need to make the Raw data ranges absolute (add $ symbols). I don't think that will cure the problem, but I suspect that it will be part of it.
We will need to see the raw data as well to be able to spot any anomalies, but even that might not be enough to identify the cause.

After your suggestion I have changed the formula as $h:$h etc. that solved my problem.
Thanks a lot.

Regards,
Amit Desai