I am trying to get the sumproduct of a range of cells for a period of time that is 3 years prior to the current year. I can't figure out what I am doing wrong. The formula I am trying to use is:
=SUMPRODUCT(IF(Z102:Z293<>0,IF(B102:B293>=EDATE(TODAY(),-36),(Z102:Z293,AE102:AE293),0)))
I want to get the sumproduct of column Z and column AE.
I don't think you need to check that column Z isn't zero, you'll get zero anyway when you multiply with AE so it doesn't affect the result.....
Try this formula
=SUMPRODUCT((B102:B293>=EDATE(TODAY(),-36))+0,Z102:Z293,AE102:AE293)
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks