Prev: Automate a Solver solution
Next: move to cells automatically by using tab button
From: Chris Reid Chris on 22 May 2010 14:17
Hello Bob,

The below function helped me start out. But I need to add the letters in
each column and give them different values and then subsequently add them for
a total of nurses scheduled. How would I go about creating that function?
Thank you so much for any help you can give.

"Bob Phillips" wrote:

> =COUNTIF(A1:A100,"*@*")
>
> --
> ---
> HTH
>
> Bob
>
> (there's no email, no snail mail, but somewhere should be gmail in my addy)
>
>
>
> "Joan NYC" <JoanNYC(a)discussions.microsoft.com> wrote in message
> news:75DDC879-6816-47A9-A405-433C2B26D33A(a)microsoft.com...
> > Aha... Sumproduct is not a function I ever tried
> >
> > I have a column of text. Some cells contain the character "@" with a
> > space
> > preceding the rest of text in the cell. I realize the @ could be
> > considered
> > an operator so it is preceded with an apostrophe to designate text. I
> > want
> > to sum the cells that have the "@"
> >
> > Thanks
> >
> > "David Biddulph" wrote:
> >
> >> You'll need to be a bit clearer as to what you're trying to do. If
> >> COUNTIF
> >> or SUMIF doesn't do the job, you may want to try SUMPRODUCT.
> >> --
> >> David Biddulph
> >>
> >> "Joan NYC" <JoanNYC(a)discussions.microsoft.com> wrote in message
> >> news:54D51227-AB8B-42DC-B3C8-64DCD126287B(a)microsoft.com...
> >> >I have been trying to calculate a column of Text in order to sum
> >> >contents
> >> >by
> >> > certain criteria
> >> >
> >> > I have tried Count, CoutA and CountIF and cannot be able to get
> >> > anything
> >> > to
> >> > work.
> >> >
> >> > Am I barking up the wrong tree? :) Can this be done?
> >> >
> >> > Thanks much.
> >>
> >>
> >>
>
>
>
>
 | 
Pages: 1
Prev: Automate a Solver solution
Next: move to cells automatically by using tab button