Hi there
I am struggling to understand why the following Countifs formula is currently returning the value Zero when is should be returning a number. I believe it has do do with <=& section of the formula but I do not understand where I haver gone wrong.
I am asking the formula to do the following
Count if the Data A = the Office and it is in the same year and if the week is smaller and equals to the week number (which is were I believe the formula stops wroking). I have also tried the following, which did not work either
Any help would be greatly appreciated
Thanks
Sam
I am struggling to understand why the following Countifs formula is currently returning the value Zero when is should be returning a number. I believe it has do do with <=& section of the formula but I do not understand where I haver gone wrong.
I am asking the formula to do the following
Count if the Data A = the Office and it is in the same year and if the week is smaller and equals to the week number (which is were I believe the formula stops wroking). I have also tried the following, which did not work either
HTML:
'Data 1'!B:B,"<="&(C3).
HTML:
COUNTIFS('Data1'!A:A,$A$11,'DATA1'!D:D,C1,'Data1'!B:B,"<"&($C$3+1),'Data1'!H:H,"<>Y")
Any help would be greatly appreciated
Thanks
Sam