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

=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

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