Formula help

D

doc

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

mkerstei

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
and will sum the corresponding value in column A.

Use the formula wizard to the left of the formula bar if you need mor
help
 
Top