[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 45
  • Last Modified:

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)
0
Mark Wood
Asked:
Mark Wood
  • 2
1 Solution
 
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

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now