Excel 2007 : Excel Calulations Question

[CanadaFriend]

i have a membership spreadsheet with a Column in which i have ACT, AFF, LIFE, ASC membership titles, then in a column next to it i have there card numbers, i already use a countif statment to count how many ACT (active) members and so on that i have, what i would like to do is also calculate how many act have paid there dues. Hope you can help?

So below we have 5 Life members, but only 3 paid. my first column would have the countif statement, but i want my second column to calculate how many paid.

Stat Card #
ACT 18751
ASC 18752
LIFE 18753
AFF 18754
LIFE 18755
LIFE 18756
LIFE
LIFE

[NBVC]

If by Paid, you mean how many members have at least one card number, then I count 4. Is that correct?

If so,

Please Login or Register  to view this content.

where A2:B9 contains the data and you have to confirm this formula with CTRL+SHIFT+ENTER not just ENTER so that you see { } brackets appear.

If not, please explain how you get 3.

[CanadaFriend]

Sorry under the Stat Column we have different abreviations, for example ACT is active members, Life is life members, and so on, the card number is issued when they pay there dues, so if john was ACT and paid his dues i would issue a card # for example 18751 which to me means paid, if no card is available then that is not paid, so i have a count if statement counting how many members i have per category, so in the below it would say i have 5 LIFE members, but the ones with the card number next to it means they paid, then i have 3 that paid.

Stat Card #
ACT 18751
ASC 18752
LIFE 18753
AFF 18754
LIFE 18755
LIFE 18756
LIFE
LIFE

So i want my report to take the data that i have and place them like this.. 5 is my count, and 3 is how many actually paid...

Thanks in advance!

[NBVC]

Then perhaps

=SUMPRODUCT(--(A2:A9="Life"),--(B2:B9<>""))

[CanadaFriend]

It worked perfectly Thank You.