Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need Function Help
undefined I am an Excel novice and I need a quick piece of advice. Let's assume I have two columns of data, for example 0 A B 1 0 2 2 1 4 3 0 4 4 0 5 5 1 6 I need to know if an If then statement can be created that if A="1", sum the corresponding values of B. In this example, the cell would return the value 10 (=4+6). I don't know the proper syntax for creating this statement, nor the proper functions to use. Any help would be greatly appreciated. -- INFOMGMTRSRCH ------------------------------------------------------------------------ INFOMGMTRSRCH's Profile: http://www.excelforum.com/member.php...o&userid=24753 View this thread: http://www.excelforum.com/showthread...hreadid=383277 |
#2
|
|||
|
|||
=SUMIF(A:A,1,B:B)
"INFOMGMTRSRCH" wrote in message news:INFOMGMTRSRCH.1rejek_1120071950.1064@excelfor um-nospam.com... undefined I am an Excel novice and I need a quick piece of advice. Let's assume I have two columns of data, for example 0 A B 1 0 2 2 1 4 3 0 4 4 0 5 5 1 6 I need to know if an If then statement can be created that if A="1", sum the corresponding values of B. In this example, the cell would return the value 10 (=4+6). I don't know the proper syntax for creating this statement, nor the proper functions to use. Any help would be greatly appreciated. -- INFOMGMTRSRCH ------------------------------------------------------------------------ INFOMGMTRSRCH's Profile: http://www.excelforum.com/member.php...o&userid=24753 View this thread: http://www.excelforum.com/showthread...hreadid=383277 |
#3
|
|||
|
|||
Good evening Infomgmtrsch No problem. The function you require is =SUMIF and using the example you have used in your posting, the syntax goes thus: =SUMIF(A1:A5,"1",B1:B5) HTH DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=383277 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions |