Wednesday, August 3, 2016

sum up group by criteria in Google Sheets


=sum(sumif(indirect(C4&"!$A$2:A"), A4, indirect(C4&"!$F$2:F"))*24)

No comments: