Been a while so I am rusty once again.

Want to sum data in dynamic range "profiledata" col 47.

If it meets the three criteria in the formula.

1st matches a number in col 16 with one in B8.

2nd matches a date greater than the date in $e$e

3rd matches a date less than the date in $d$4

=SUMPRODUCT(--(INDEX(profiledata,,16)=B8),--(INDEX(profiledata,,46)>$E$4),--(INDEX(profiledata,,46)<$D$4),--(INDEX(profiledata,,47)))

Do I need an OR in there somewhere as I just get #VALUE! as a result even if entered as an array formula.

Please help out a rusty fellow