COUNTIFS Query

[SamanthaC]

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

'Data 1'!B:B,"<="&(C3).

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

 

[squirrel31]

Have you tried evaluating the formula using excel evaluate formula feature? (Locatable in the formulas tab). Additionally, you may find it quicker and easier for others to post a snippet of an example that also shows your expected results.