Formula:
=sumproduct(($a$3:$a$22=$e3)*(year($c$3:$c$22)=year(f$2))*(month($c$3:$c$22)=month(f$2))*$b$3:$b$22)
Formula:
=sumproduct(($a$3:$a$22=$e3)*(year($c$3:$c$22)=year(f$2))*(month($c$3:$c$22)=month(f$2))*$b$3:$b$22)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks