Forum Discussion
Formula needed
I need a formula that sums the values with the criteria onsite offsite. Can anybody help, please?
Let's say on/offsite is in C2:C30 and Dauer in F2:F30
=SUMIFS(F2:F30, C2:C30, "onsite")
and
=SUMIFS(F2:F30, C2:C30, "offsite")
In German:
=SUMMEWENNS(F2:F30; C2:C30; "onsite")
and
=SUMMEWENNS(F2:F30; C2:C30; "offsite")