Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Add numbers depending on other cells
Hi, I need to add up some values depending what is in the cell next to them A B 1 Cat 2 2 Dog 3 3 Cat 5 4 Rabbit 6 So i need to add up all the numbers in colum B that are next to cat - is this possible? Thanks, -- babygoode ------------------------------------------------------------------------ babygoode's Profile: http://www.excelforum.com/member.php...o&userid=26109 View this thread: http://www.excelforum.com/showthread...hreadid=401319 |
#2
|
|||
|
|||
=SUMIF(a1:a4, "cat",b1:b4) or =SUMIF(a1:a4,c1,b1:b4) so that you can enter cat or rabbit in c1 -- bill k ------------------------------------------------------------------------ bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821 View this thread: http://www.excelforum.com/showthread...hreadid=401319 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing named range reference depending on a cell's content | Excel Discussion (Misc queries) | |||
excel is adding cell numbers randomly into other cells | Excel Worksheet Functions | |||
update row numbers after different active cells in macros followi. | Excel Discussion (Misc queries) | |||
Converting negative numbers in a range of cells to zero | Excel Discussion (Misc queries) | |||
combining several individual cells of numbers into one cell | Excel Worksheet Functions |