Hi,
I am trying to sum data if the date in column D is before 2014 and if the value in row 2 of that coulmn matches the value in E4 (Q1, Q2...). This is the sum product I am using but it is not picking up any values.
=SUMPRODUCT(('FAC Open POs'!$D:$D<DATE(2014,1,1))*('FAC Open POs'!T2:AG2='Cash Waterfall'!E4)*('FAC Open POs'!T:AG))
Thanks,
Justin Picardi
Bookmarks