Excel formula help

I am trying to create a formula  where if 2 fields = the right values then it goes down and returns the total. I have tried the formula below and it doesn't work. please help.

=SUMIF(AND(Materials!A4:A503,"=Pac-Van",Materials!E4:E503,"=Purchased By Church"),Materials!B4:B503)
LVL 2
Mark WoodNetwork AdministratorAsked:
Who is Participating?
 
ProfessorJimJamCommented:
try

=SUMIFS(Materials!B4:B503,Materials!A4:A503,"Pac-Van",Materials!E4:E503,"Purchased By Church")
0
 
Mark WoodNetwork AdministratorAuthor Commented:
Thanks
0
 
ProfessorJimJamCommented:
you are welcome.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.