Seamus2626

asked on

# 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

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

ASKER CERTIFIED SOLUTION

membership

Create an account to see this answer

Signing up is free. No credit card required.

SOLUTION

membership

Create an account to see this answer

Signing up is free. No credit card required.

ASKER