i've got a list of values that need summing, but only if i certain value is in another cell:
a b
1 paid
1 paid
1 not
1 paid
1 not
i need a formula that will count all the values in column a only if column b is set to "paid"
i've got a list of values that need summing, but only if i certain value is in another cell:
a b
1 paid
1 paid
1 not
1 paid
1 not
i need a formula that will count all the values in column a only if column b is set to "paid"
Re: Sum Of A List But Only When Another Cell Has Certain Values
Perhaps SUMIF or COUNTIF could be a beginning
[frc]
=SUMIF(B2:B6,"paid",A2:A6)
=COUNTIF(B2:B6,"paid")
[/frc]
Re: Sum Of A List But Only When Another Cell Has Certain Values
Does anyone search before asking?
*walks off muttering having bad day*
BTW, cue Dave...
Re: Sum Of A List But Only When Another Cell Has Certain Values
Hmmm. Above average skill level? Nope.
Re: Sum Of A List But Only When Another Cell Has Certain Values
At least the hasn't rated themselves above average. But you have to wonder why even basic users cannot search.
Don’t have an account yet? Register yourself now and be a part of our community!