Formula help
 

I need to get a specific total from the following criteria. I have data
in 2 columns and need to get a total based upon specific entries in the
cells in thoses columns. For example what is the total dollars in
column A when the entry in column B is N?


--
doc
------------------------------------------------------------------------
doc's Profile: http://www.excelforum.com/member.php...fo&userid=1434
View this thread: http://www.excelforum.com/showthread...hreadid=392274

Use the =sumif command.
your equation would look like this:
=sumif(B1:B19,"n",A1:A19)
This means that excel will look in column B for any values that equal N
and will sum the corresponding value in column A.

Use the formula wizard to the left of the formula bar if you need more
help.


--
mkerstei
------------------------------------------------------------------------
mkerstei's Profile: http://www.excelforum.com/member.php...o&userid=25688
View this thread: http://www.excelforum.com/showthread...hreadid=392274

Thanks...Worked great


--
doc
------------------------------------------------------------------------
doc's Profile: http://www.excelforum.com/member.php...fo&userid=1434
View this thread: http://www.excelforum.com/showthread...hreadid=392274