Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Search a worksheet and add related cells
Is there a quick way to search a row for a particular word (Jan) and then add all the cells directly above the word (Jan)? For example: 464 565 5656 565 5656 788 Jan Feb Feb Jan Feb Jan I am looking to add together the values only above the word "Jan" -- izbryte ------------------------------------------------------------------------ izbryte's Profile: http://www.excelforum.com/member.php...o&userid=16740 View this thread: http://www.excelforum.com/showthread...hreadid=319491 |
#2
|
|||
|
|||
=SUMIF(2:2,"Jan",1:1)
HTH Jason Atlanta, GA -----Original Message----- Is there a quick way to search a row for a particular word (Jan) and then add all the cells directly above the word (Jan)? For example: 464 565 5656 565 5656 788 Jan Feb Feb Jan Feb Jan I am looking to add together the values only above the word "Jan" -- izbryte --------------------------------------------------------- --------------- izbryte's Profile: http://www.excelforum.com/member.php? action=getinfo&userid=16740 View this thread: http://www.excelforum.com/showthread...hreadid=319491 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|