[quote=Flashyfuture;1093298]Hello VIPS,
I need help on calculating the total Classroom hours separate from the Elearning hours without converting it to a datatable or any related format.
Methodology Hours
========= =====
Classroom 13
Elearning 20
Classroom 14
Classroom 15
Elearning 223
Outdoor 27
Outdoor 34
Classroom (Total) = =Sum((A3:A9="Classroom")*(B3:B9))
ELearning (Total) = =Sum((A3:A9="ELearning")*(B3:B9))
Outdoor = =Sum((A3:A9="Outdoor")*(B3*B9))
Explanation
You have to enter the formular as an array. How? Type the formular but instead of pressing enter, press CTRL+SHIFT+ENTER.
Assumptions:
'Methodology' data occupies the range A3:A9 on your worksheet
'Hours' data occupies the range B3:B9 on your worksheet.
Don't forget, enter the formular as an ARRAY by pressing Ctrl+Shift+Enter, even when you edit it. The curly bracket ({}) is introduced whenever this is done so your formula becomes:
{=Sum((A3:A9="Classroom")*(B3:B9))}
Thank God!
