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)
=SUMIFS(Materials!B4:B503,