Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 224
  • 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
 
helpfinderCommented:
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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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