G
Guest
Hello everyone
I have a sheet where I want to count items based on two different columns of criteria. I tried this formula
=COUNTIF(and(Task_Table1!A2:A1722="CMDT",Task_Table1!f2:f1722="Late"),
but get the usual error. So I checked Microsoft and they offe this workaround to count number values
=sum(IF(Task_Table1!A2:A1722="CMDT") + (Task_Table1!J2:J1722="Late"),1,0)
this does not work either. I want to count tasks where ProjID = CMDT AND Status = Lat
Any ideas
I have a sheet where I want to count items based on two different columns of criteria. I tried this formula
=COUNTIF(and(Task_Table1!A2:A1722="CMDT",Task_Table1!f2:f1722="Late"),
but get the usual error. So I checked Microsoft and they offe this workaround to count number values
=sum(IF(Task_Table1!A2:A1722="CMDT") + (Task_Table1!J2:J1722="Late"),1,0)
this does not work either. I want to count tasks where ProjID = CMDT AND Status = Lat
Any ideas