Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

countif? cont.

0 views
Skip to first unread message

John

unread,
May 21, 2003, 3:18:54 PM5/21/03
to

I should have mentioned that the cells also contain other
data, ie:
apple*
orange**
kiwi
grape**

When using the "~*" for countif it won't count the data.

The pivot table reports back then # of instances
orange**. Which is good but I need a grand total for all
** for the entire column.

Make sense?

Thanks,
Novice Excel user

I am attempting to count the number of asterisks that
appear in a column. Some cells contain single asterisks
while others contain 2.

I want to be able to count how many cells contain 1
asterisk and how many contain 2.

I tried countif but it returns all instances of asterisks
it finds?

Can anyone point me in the right direction?


S. Peter

unread,
May 22, 2003, 1:58:50 AM5/22/03
to
Dear John

Please try Array Formulas as this fuction =SUM(IF(RIGHT(B1:B14,2)="**",1,0))
and then press Ctrl+Shift+Enter

This function will count the cell that contain two asterisks at the right of
your data

Best regards

Pravit S.

"John" <catd...@yahoo.com> wrote in message
news:0a7201c31fcd$d18050b0$a001...@phx.gbl...

0 new messages