Need to count a row after two criterions are met

[mmayna03]

I have to sum up all the values of one column based upon criteria from two columns, Sorry if this question has been asked a brazilian times.

here is my formula:

=COUNTIFS(Sponsorships!B:B,"1", Sponsorships!I:I,"Homes",Sponsorships!D:D)

I need B:B to equal 1 and I:I to equal Homes, for D:D to add up based upon the two conditions.

Thanks,

Michael

 

[pagrender]

If you are trying to add the amounts from column D, you will need a SUMIFS formula. Something like this...

=SUMIFS(Sponsorships!D:D,Sponsorships!B:B,1, Sponsorships!I:I,"Homes")

I changed the "1" to 1. You may need to change it back if the "1" is text.

 

[pagrender]

I'm rereading your post...

Are there values in Column D? Or do you just want one formula in column D that adds up all the "1"s in column B?

 

[mmayna03]

pagrender,

Thank you, your first post answered my question. I am adding up the values in column D.

Based upon your anwer in the first reply, the expected value was returned.

Thank you for your expertise.

Michael

 

[pagrender]

Thanks for the feedback!