hi,
thanks in advance to everyone that looks at my post.
I have a formula that I want to use to count from a closed workbook and I think I have it working but it just returns a zero instead of a figure.
here's my formula: =SUMPRODUCT(('[Data Ops Progress - Radio P1801-P1810.xlsx]ACBC - Paper'!$A:$A=P1804)*( '[Data Ops Progress - Radio P1801-P1810.xlsx]ACBC - Paper'!$X:$X>=$C$3)*('[Data Ops Progress - Radio P1801-P1810.xlsx]ACBC - Paper'!$X:$X<=$C$4),'[Data Ops Progress - Radio P1801-P1810.xlsx]ACBC - Paper'!$V:$V)
unfortunately I don't know what the count should be either but I'm sure not zero or one
any help is much appreciated
Dave
Bookmarks