=sum(if(AllCosts!M$18:M$2010<>"",(month(AllCosts!$B$18:$B$2010)=$B6)*(year(AllCosts!$B$18:$B$2010)=$D6)*AllCosts!M$18:M$2010)) as SCE
=sum(if(AllCosts!M$18:M$2010<>"",(month(AllCosts!$B$18:$B$2010)=$B6)*(year(AllCosts!$B$18:$B$2010)=$D6)*AllCosts!M$18:M$2010)) as SCE
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks