sumif function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to sum a column if it is equal to 2 different columns
(i.e. if column A=1 and column D=expense, then sum column
but if if A=1 and D=capital, I do not want to sum column c.
I am having a hard time putting the 2 criteria into the sumif function.
Any help would be so greatfully appreciated.
 
Hi,

While you are all in the sumif mood :)

I would like to know how to fix the following:

sumif(A1:a5,'=daivd',b1:b5)

I would like to make david a cell refernce rather than hard code it
eg.

sumif(A1:A5,'=C10",b1:b5)

Doing the above i get a 0 return. Any thoughts

Regard
 
Back
Top