Hi everyone,
I have come across a small problem which I could use a fresh pair of eyes on.
I am basically trying to use formula to populate a stats table with data from my list.
From my list I would like to count a figure of certain occurences in several columns.
e.g
Columns A to D:
Job, Job Code, Area, SLA Pass/Fail
I need to count the number of passes/fails for specific job types in my list which contain certain area codes. And then populate a pre-designed table with the relevant info.
I have tried =sumproduct((Jobcode="__")*(Area="__")*(Pass/Fail="pass"))
which gives me a result of 0 despite there being dozens of occasions where my criteria is met.
I would appreciate it if someone could help me out with where I am going wrong. Is the function specific for numbers or something?
I have come across a small problem which I could use a fresh pair of eyes on.
I am basically trying to use formula to populate a stats table with data from my list.
From my list I would like to count a figure of certain occurences in several columns.
e.g
Columns A to D:
Job, Job Code, Area, SLA Pass/Fail
I need to count the number of passes/fails for specific job types in my list which contain certain area codes. And then populate a pre-designed table with the relevant info.
I have tried =sumproduct((Jobcode="__")*(Area="__")*(Pass/Fail="pass"))
which gives me a result of 0 despite there being dozens of occasions where my criteria is met.
I would appreciate it if someone could help me out with where I am going wrong. Is the function specific for numbers or something?