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