Countifs part2

[turtel]

Hi All,

Good morning everyone, I have another question about countifs. I have a column with different tests (column B) and a column with TAT >5 (column G) on a worksheet with three tabs called Summary data, January and February. In the summary data tab, I need to count how many a certain test in the January and February tabs has a TAT >5. I used this formula =COUNTIFS(January:February!B6:B227,B45,January:February!P6:P227,">5") and i'm getting a "#VALUE!" message on the cell. I uploaded a sample worksheet. Any help would be appreciated, thanks.

 

[Luke M]

Short answer, COUNTIF doesn't support 3D references (referencing multiple sheets). You could put a formula on each sheet, and then use a 3D SUM to add them all up.

 

[turtel]

Thanks for the advice Luke M, that's what I did.