sumif function

[confused]

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.

 

[Nym01]

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

 

[Vasant Nanavati]

=SUMIF(A1:A5,C10,B1:B5)

 

[Vasant Nanavati]

=SUMPRODUCT((A1:A100=1)*(D1100="expense")*(C1:C100))

 

[Nym01]

cheers Vasant.

thanks for your help