can excel calculate a letter

[kristi _ 71]

i need to make a spreadsheet , with it able to calculate the letter p in a
cell and total at the bottom of the sheet

[Myrna Larson]

What do you mean by "calculate the letter p"? Insert that character into a
cell? Make it part of the formula result? Just display it without making it a
part of the data?

On Tue, 22 Feb 2005 17:59:02 -0800, "kristi _ 71" <kristi _ 71
@discussions.microsoft.com> wrote:

>i need to make a spreadsheet , with it able to calculate the letter p in a
>cell and total at the bottom of the sheet

[kristi _ 71]

well ,,, i need it to count all the (P') ... i will put a p in each cell ...
i need it to calculate it at the bottom... i messed the formula up somehow
and i dont know how to fix it right


"Myrna Larson" wrote:

> What do you mean by "calculate the letter p"? Insert that character into a
> cell? Make it part of the formula result? Just display it without making it a
> part of the data?
>
> On Tue, 22 Feb 2005 17:59:02 -0800, "kristi _ 71" <kristi _ 71
> @discussions.microsoft.com> wrote:
>
> >i need to make a spreadsheet , with it able to calculate the letter p in a
> >cell and total at the bottom of the sheet
>
>

[Myrna Larson]

=COUNTIF(B2:B58,"p")

Change the reference to the range you want to count.

On Tue, 22 Feb 2005 19:19:04 -0800, "kristi _ 71"
<[email protected]> wrote:

>well ,,, i need it to count all the (P') ... i will put a p in each cell ...
>i need it to calculate it at the bottom... i messed the formula up somehow
>and i dont know how to fix it right
>
>
>"Myrna Larson" wrote:
>
>> What do you mean by "calculate the letter p"? Insert that character into a
>> cell? Make it part of the formula result? Just display it without making it
a
>> part of the data?
>>
>> On Tue, 22 Feb 2005 17:59:02 -0800, "kristi _ 71" <kristi _ 71
>> @discussions.microsoft.com> wrote:
>>
>> >i need to make a spreadsheet , with it able to calculate the letter p in a
>> >cell and total at the bottom of the sheet
>>
>>

[kristi _ 71]

HOW DO I CHANGE THER REFERENCE .. I M NOT SURE WHAT EXACT STEPS I NED TO TAKE
,,, OR HOW TO IMPUT THE FORMULAS


"Myrna Larson" wrote:

>
>
> =COUNTIF(B2:B58,"p")
>
> Change the reference to the range you want to count.
>
> On Tue, 22 Feb 2005 19:19:04 -0800, "kristi _ 71"
> <[email protected]> wrote:
>
> >well ,,, i need it to count all the (P') ... i will put a p in each cell ...
> >i need it to calculate it at the bottom... i messed the formula up somehow
> >and i dont know how to fix it right
> >
> >
> >"Myrna Larson" wrote:
> >
> >> What do you mean by "calculate the letter p"? Insert that character into a
> >> cell? Make it part of the formula result? Just display it without making it
> a
> >> part of the data?
> >>
> >> On Tue, 22 Feb 2005 17:59:02 -0800, "kristi _ 71" <kristi _ 71
> >> @discussions.microsoft.com> wrote:
> >>
> >> >i need to make a spreadsheet , with it able to calculate the letter p in a
> >> >cell and total at the bottom of the sheet
> >>
> >>
>
>

[Myrna Larson]

Rewrite the formula so instead of B2:B58, it refers to the cells you want.


On Tue, 22 Feb 2005 20:25:02 -0800, "kristi _ 71"
<[email protected]> wrote:

>HOW DO I CHANGE THER REFERENCE .. I M NOT SURE WHAT EXACT STEPS I NED TO TAKE
>,,, OR HOW TO IMPUT THE FORMULAS
>
>
>"Myrna Larson" wrote:
>
>>
>>
>> =COUNTIF(B2:B58,"p")
>>
>> Change the reference to the range you want to count.
>>
>> On Tue, 22 Feb 2005 19:19:04 -0800, "kristi _ 71"
>> <[email protected]> wrote:
>>
>> >well ,,, i need it to count all the (P') ... i will put a p in each cell
....
>> >i need it to calculate it at the bottom... i messed the formula up somehow
>> >and i dont know how to fix it right
>> >
>> >
>> >"Myrna Larson" wrote:
>> >
>> >> What do you mean by "calculate the letter p"? Insert that character into
a
>> >> cell? Make it part of the formula result? Just display it without making
it
>> a
>> >> part of the data?
>> >>
>> >> On Tue, 22 Feb 2005 17:59:02 -0800, "kristi _ 71" <kristi _ 71
>> >> @discussions.microsoft.com> wrote:
>> >>
>> >> >i need to make a spreadsheet , with it able to calculate the letter p
in a
>> >> >cell and total at the bottom of the sheet
>> >>
>> >>
>>
>>

[GY]

hi there,
can u tell me how to link this result to another worksheet?
say on another sheet, i would need to calculate the Ps, but would also like
to accumulate the Ps from the previous sheet?

thanks very much for ur help!

"Myrna Larson" wrote:

> Rewrite the formula so instead of B2:B58, it refers to the cells you want.
>
>
> On Tue, 22 Feb 2005 20:25:02 -0800, "kristi _ 71"
> <[email protected]> wrote:
>
> >HOW DO I CHANGE THER REFERENCE .. I M NOT SURE WHAT EXACT STEPS I NED TO TAKE
> >,,, OR HOW TO IMPUT THE FORMULAS
> >
> >
> >"Myrna Larson" wrote:
> >
> >>
> >>
> >> =COUNTIF(B2:B58,"p")
> >>
> >> Change the reference to the range you want to count.
> >>
> >> On Tue, 22 Feb 2005 19:19:04 -0800, "kristi _ 71"
> >> <[email protected]> wrote:
> >>
> >> >well ,,, i need it to count all the (P') ... i will put a p in each cell
> ....
> >> >i need it to calculate it at the bottom... i messed the formula up somehow
> >> >and i dont know how to fix it right
> >> >
> >> >
> >> >"Myrna Larson" wrote:
> >> >
> >> >> What do you mean by "calculate the letter p"? Insert that character into
> a
> >> >> cell? Make it part of the formula result? Just display it without making
> it
> >> a
> >> >> part of the data?
> >> >>
> >> >> On Tue, 22 Feb 2005 17:59:02 -0800, "kristi _ 71" <kristi _ 71
> >> >> @discussions.microsoft.com> wrote:
> >> >>
> >> >> >i need to make a spreadsheet , with it able to calculate the letter p
> in a
> >> >> >cell and total at the bottom of the sheet
> >> >>
> >> >>
> >>
> >>
>
>

[Biff]

Hi!

Assume you want to count "P's" on both Sheet1 and Sheet2.

The formula is in Sheet1:

=COUNTIF(Sheet2!A1:A10,"P")+COUNTIF(A1:A10,"P")

OR:

=SUMPRODUCT((Sheet2!A1:A10="P")+(A1:A10="P"))

Biff

>-----Original Message-----
>hi there,
>can u tell me how to link this result to another
worksheet?
>say on another sheet, i would need to calculate the Ps,
but would also like
>to accumulate the Ps from the previous sheet?
>
>thanks very much for ur help!
>
>"Myrna Larson" wrote:
>
>> Rewrite the formula so instead of B2:B58, it refers to
the cells you want.
>>
>>
>> On Tue, 22 Feb 2005 20:25:02 -0800, "kristi _ 71"
>> <[email protected]> wrote:
>>
>> >HOW DO I CHANGE THER REFERENCE .. I M NOT SURE WHAT
EXACT STEPS I NED TO TAKE
>> >,,, OR HOW TO IMPUT THE FORMULAS
>> >
>> >
>> >"Myrna Larson" wrote:
>> >
>> >>
>> >>
>> >> =COUNTIF(B2:B58,"p")
>> >>
>> >> Change the reference to the range you want to count.
>> >>
>> >> On Tue, 22 Feb 2005 19:19:04 -0800, "kristi _ 71"
>> >> <[email protected]> wrote:
>> >>
>> >> >well ,,, i need it to count all the (P') ... i will
put a p in each cell
>> ....
>> >> >i need it to calculate it at the bottom... i messed
the formula up somehow
>> >> >and i dont know how to fix it right
>> >> >
>> >> >
>> >> >"Myrna Larson" wrote:
>> >> >
>> >> >> What do you mean by "calculate the letter p"?
Insert that character into
>> a
>> >> >> cell? Make it part of the formula result? Just
display it without making
>> it
>> >> a
>> >> >> part of the data?
>> >> >>
>> >> >> On Tue, 22 Feb 2005 17:59:02 -0800, "kristi _ 71"
<kristi _ 71
>> >> >> @discussions.microsoft.com> wrote:
>> >> >>
>> >> >> >i need to make a spreadsheet , with it able to
calculate the letter p
>> in a
>> >> >> >cell and total at the bottom of the sheet
>> >> >>
>> >> >>
>> >>
>> >>
>>
>>
>.
>