• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 226
  • Last Modified:

sumproduct

If i have two columns

one

High          25
High          50
Low           75
Medium    10
High          35

How can use some formula to calculate the sum of col b if col a = "High"

Many thanks
0
Seamus2626
Asked:
Seamus2626
2 Solutions
 
Dan CraciunIT ConsultantCommented:
SUMIF("A:A", "=High", "B:B")

HTH,
Dan
0
 
helpfinderIT ConsultantCommented:
you can use SUMIF formula for this case
=SUMIF(A1:A5;"High";B1:B5)

\\Dan is obviously faster typer :)
0
 
Seamus2626Author Commented:
Thanks lads!
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.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

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