Remember Me?

#1
 Junior Member Posts: 2
Summation based on contents of another cells

Hello VIPS,

I need help on calculating the total Classroom hours separate from the E-learning hours without converting it to a data-table or any related format.

Methodology Hours
========= =====
Classroom 13
E-learning 20
Classroom 14
Classroom 15
E-learning 223
Outdoor 27
Outdoor 34

Classroom (Total) =
E-Learning (Total) =
Outdoor =
#2
 Junior Member Posts: 2

[quote=Flashyfuture;1093298]Hello VIPS,

I need help on calculating the total Classroom hours separate from the E-learning hours without converting it to a data-table or any related format.

Methodology Hours
========= =====
Classroom 13
E-learning 20
Classroom 14
Classroom 15
E-learning 223
Outdoor 27
Outdoor 34

Classroom (Total) = =Sum((A3:A9="Classroom")*(B3:B9))
E-Learning (Total) = =Sum((A3:A9="E-Learning")*(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!

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post adam Excel Discussion (Misc queries) 2 October 29th 07 09:11 PM xjetjockey Excel Worksheet Functions 4 January 2nd 07 10:21 PM Debbie Excel Discussion (Misc queries) 1 December 22nd 06 06:33 PM George Excel Discussion (Misc queries) 3 November 8th 05 02:33 PM George Excel Worksheet Functions 3 November 7th 05 06:39 PM

All times are GMT +1. The time now is 08:12 PM.