If Statements

[anat]

I have 2 cells with asterics in them, D11 and I11. I am trying to write a
forumla using if statement
=IF(D11="*",1,"")
How could I combine both cells to add them if they both have *?

Thanks

[JE McGimpsey]

one way:

=COUNTIF(D11,"~*")+COUNTIF(I11,"~*")

In article <[email protected]>,
"anat" <[email protected]> wrote:

> I have 2 cells with asterics in them, D11 and I11. I am trying to write a
> forumla using if statement
> =IF(D11="*",1,"")
> How could I combine both cells to add them if they both have *?
>
> Thanks

[anat]

Sorry I should have been more clear:

Col X should look at D and I and total the number of astericks. Col Y
should total the cells without astericks.

Thanks

"JE McGimpsey" wrote:

> one way:
>
> =COUNTIF(D11,"~*")+COUNTIF(I11,"~*")
>
> In article <[email protected]>,
> "anat" <[email protected]> wrote:
>
> > I have 2 cells with asterics in them, D11 and I11. I am trying to write a
> > forumla using if statement
> > =IF(D11="*",1,"")
> > How could I combine both cells to add them if they both have *?
> >
> > Thanks
>

[JE McGimpsey]

Perhaps I'm dense, but I'm not understanding here...

Do you want to count asterisks in each row, columns D & I, putting the
result in column X of that row?

Or do you want to count all the asterisks in columns D & I and put that
in some cell in column X? If so, how many rows should be looked at for
the value that goes into the cell in column Y (i.e., cells without
asterisks)?



In article <[email protected]>,
"anat" <[email protected]> wrote:

> Sorry I should have been more clear:
>
> Col X should look at D and I and total the number of astericks. Col Y
> should total the cells without astericks.

[anat]

Yes, I want to count the number of asterisks in each row (of columns D & I)
and put the result in column X of that row. And if it has no asterisks count
the blanks and put the results in Col Y since the asterisks represents a type
of an employee.

Thanks



"JE McGimpsey" wrote:

> Perhaps I'm dense, but I'm not understanding here...
>
> Do you want to count asterisks in each row, columns D & I, putting the
> result in column X of that row?
>
> Or do you want to count all the asterisks in columns D & I and put that
> in some cell in column X? If so, how many rows should be looked at for
> the value that goes into the cell in column Y (i.e., cells without
> asterisks)?
>
>
>
> In article <[email protected]>,
> "anat" <[email protected]> wrote:
>
> > Sorry I should have been more clear:
> >
> > Col X should look at D and I and total the number of astericks. Col Y
> > should total the cells without astericks.
>

[JE McGimpsey]

One way:

X1: =(D1="*")+(I1="*")
Y1: =2-X1

Select X1 and Y1 and copy down as far as necessary.

In article <[email protected]>,
"anat" <[email protected]> wrote:

> Yes, I want to count the number of asterisks in each row (of columns D & I)
> and put the result in column X of that row. And if it has no asterisks count
> the blanks and put the results in Col Y since the asterisks represents a type
> of an employee.