cut and move cell looses value

[Henley18]

As attached have two problems
1. Formula in E9 works perfectly. Same formula in H9 produces 0, and moving E9 to H9 does the same thing.
"=SUMIFS(Table1[[#All],[Month Value]],Table1[[#All],[Code]],$B10,Table1[[#All],[Department]],$E$5:$H$5,Table1[[#All],[Month]],$E$6)"

2. Formula in G2 produces rubbish instead of " Budget"
"=TEXT(DATE(YEAR($E6),MONTH($E6),1),"mmm-yy"&" budget")"

Any solutions or suggestions welcome.

Henley18

[sandy666]

maybe try : =TEXT(DATE(YEAR($E6),MONTH($E6),1),"mmm-yy")&" budget"
@#1: edit formula in H9 and hit Control+Shift+Enter instead Enter only or try
=SUMPRODUCT(database!E2:E14*(database!A2:A14=B10)*(database!G2:G14=E5)*(database!D2:D14=E6))
iinstead of SUMIFS
use $$ if necessary

[avk]

Try

Please Login or Register  to view this content.