Hello there...I realize this is not exactly the best place for an excel question but i had nowhere to turn. If anyone knows how to create these two formulas it'd be a huge help. I no very little excel.

1. I am tring to get the count of DISTINCT values in a ranges not including blanks. I have this so far whis counts ignoring blanks but counts duplicates as 2 not one.

=COUNTA(B20:B50)

2. There is 2 columns beside each other. One with numbers, the one beside with wither an 'A' or "I' (for active and inactive). I would like to capture the sum of all the values with an 'A' beside it. I have no idea where to start on htat one???

Thanks in advance!!!!!!