Link to home
Create AccountLog in
Avatar of Seamus2626
Seamus2626Flag for Ireland

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
ASKER CERTIFIED SOLUTION
Avatar of Dan Craciun
Dan Craciun
Flag of Romania image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Seamus2626

ASKER

Thanks lads!