Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 2
Exclamation 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   Report Post  
Junior Member
 
Posts: 2
Talking

[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!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
making # + or - based on another cells contents adam Excel Discussion (Misc queries) 2 October 29th 07 10:11 PM
Finding a value based on contents of two cells xjetjockey Excel Worksheet Functions 4 January 2nd 07 11:21 PM
How do I add a cell based on another cells contents? Debbie Excel Discussion (Misc queries) 1 December 22nd 06 07:33 PM
Counting based on other cells contents... George Excel Discussion (Misc queries) 3 November 8th 05 03:33 PM
Complicated counting of cells (based on other cells contents) George Excel Worksheet Functions 3 November 7th 05 07:39 PM


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

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"