Try then:
copied down![]()
=SUMPRODUCT((C2:G2>=DATE(YEAR(TODAY())-2,MONTH(TODAY()),DAY(TODAY())))*(B2:F2<"Jan 1, 1901"+0)*(B2:F2))
Try then:
copied down![]()
=SUMPRODUCT((C2:G2>=DATE(YEAR(TODAY())-2,MONTH(TODAY()),DAY(TODAY())))*(B2:F2<"Jan 1, 1901"+0)*(B2:F2))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks