Try =SUMIF(D4:D54,"Solar",T4:T54)/SUMPRODUCT((D4:D54,"Solar")*(T4:T54>0))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Forum Rules
Bookmarks