'If' query

[Guest]

Following on from my spreadsheet issues just now - i also need to add up on
each sheet how many in column W = N and how many = U. These need to be
converted into number form (ie 4 Ns and 15 Us) on the month end sheet. By
the way, the month end sheet is a summary which has the 1 -31 days totals on
it. HELP pleeeease!!

 

[r.creedon]

Following on from my spreadsheet issues just now - i also need to add up on
each sheet how many in column W = N and how many = U. These need to be
converted into number form (ie 4 Ns and 15 Us) on the month end sheet. By
the way, the month end sheet is a summary which has the 1 -31 days totals on
it. HELP pleeeease!!

Hi

You need to use the countif function. This formula will count the
number of instances a peice of data occurs within a set range.

There are two possibilties

1) If the cells in column W will only contain either U, or N or any
other single digit then you type:

=countif(W1:W?,"N") - obviously the question
mark represents the end cell of your W column. You can then do the
same for the Us.

2) However, if the cells may contain other pieces of data, as well as
either the U or the N, then you need to add the wildcard symbol which
is *. This will find the desired data amongst other pieces of data
should there be any. so then you must type

=countif(W1:W?,"*N*")

Hope this helps

Rory

 

[Roger Govier]

Hi

="there are "&COUNTIF(W:W,"N")&" N's and "COUNTIF(W:W,"U")&" U's)