Search : in
By :

Calculate the sum if two different conditions

Last answer on Oct 8, 2009 5:37:40 am BST jyotishdev_g, on Jul 1, 2009 6:58:37 pm BST 
 Report this message to moderators

Hello,
If in column a:a if have numbers 1 to 5 and in column b:b i have a and b randomly and finally in cloumn c:c, i have different time say, 12min, 20 min etc, then In sheet two I want the sum of all the time if in cell a1 it is 2 and cell b1 it is a and like wise. Basically if
A B C
1 b 12
2 a 10
2 a 05
4 b 04
5 b 15

what i want is a formula that will calculate 10 and 05 and give the result as 15

Configuration: Windows XP Internet Explorer 6.0

Best answers for « calculate the sum if two different conditions » in :
[Memory]How to make use Dual Channel Show[Memory]How to make use Dual Channel Some memory controllers provide a dual channel for memory. The aim is to use the memory modules in pairs and combining it to the bandwidth and thus maximizing the capacity of the system. Note it is...
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
Colouring cells on conditions ShowColouring cells on conditions There are many pratical functions under Excel which is not commonly used. Example: If you wish a cell automatically turns red (or other formatting border, frame etc) under one condition: a result, a...
Download Multiple Database Query Analyzer Show
Download MacIP Change ShowMacIP Changes partners a very good developed program sous C ++. It is intended for the users who work in computer network LAN. MacIP Changes deal the possibility of changing fast and several times if necessary different shapes LAN, that...
Download DVDFab Platinum ShowDVDFab Platinum allows you ot copy DVD. The program offers 8 different copy modes: Full disk, main movie, to split, to customize, Clone, to merge and to write data. It can: - copy onto a double layer DVD - copy onto 2 different disks - copy...
NAT- Network address translation, port forwarding and port trigg ShowThe principle of NAT Network address translation or NAT was developed in order to respond to the shortage of IP addresses with IPv4 protocol (in time the IPv6 protocol will respond to this problem). In fact, in IPv4 addressing the number of...
Spreadsheets - Conditional expressions ShowWhat is a Conditional Structure? Conditional structures are instructions that allow to test if a condition is true or not. Conditional structures may be associated together. To successfully execute these tests using logical functions, spreadsheets...
Types of networks ShowDifferent types of networks Different types of (private) networks are distinguished based on their size (in terms of the number of machines), their data transfer speed, and their reach. Private networks are networks that belong to a single...
Ask your question Reply

1

venkat1926, on Jul 2, 2009 1:15:33 am BST
  • +5

In an empty cell type this formula and see

=SUMPRODUCT(($A$1:$A$5=2)*($B$1:$B$5="a")*($C$1:$C$5))

modify the formula to suit you.

   
Reply to venkat1926

2

joe, on Jul 2, 2009 5:08:51 pm BST

Thanks venky

   
Reply to joe

3

 Mahesh, on Oct 8, 2009 5:37:40 am BST

Thanx Yar...Good one....

   
Reply to Mahesh
Ask your question Reply
They need your help