Formulas over several sheets and cells

[Ziro54]

Hi,

I am not sure if there is a solution to this. I have a Workbook where I capture information. I have added some formulas ease the process. I have a Dashboard Worksheet that summarize some data. The formula is [COUNTIFS('Incident Register'!$B$5:$B$2001,'Data Sheet'!A4,'Incident Register'!$M$5:$M$2001,"Yes")]. I want [IF(B4="","",) in front. I get a [#value] error on my Dashboard. The formula on my DashBoard is [IF(N6<>"",(SUM(('Data Sheet'!$A$4:$R$1000>=$E$9)*('Data Sheet'!$A$4:$A$1000<=$N$6)*('Data Sheet'!$R$4:$R$1000))),"")]. N6 you enter today's date manually.

Is there something else I can use? Or a way to fix this?

 

[Fluff]

Glad you sorted it & thanks for the feedback.

 

[Ziro54]

Glad you sorted it & thanks for the feedback.

I celebrated too early. HAHAHA. Thanks for all your help. From what I can gather, the #value error is due to the cells not having any numbers in them yet. The moment they are filled, so basically end of the week, the error disappear. I am not sure if there is a way to update the formula range according to [today()]?

 

[Fluff]

I've no idea as the formula you said worked, bears absolutely no resemblance to the formulae you initially posted.