As i am running a business i have to deal with some clients who are regular
with me.So for which i use excel to put in their data.So what i would like
is.....is it possible that i can type somewhere in that excel sheet and check
for that particular client example suppose"Sandy" is my client.So i would to
check how much of business(in terms of money) has sandy given me.
Is that possible to be made or please tell me which office product can be
used to do the same
Please help me

Sandy

sure

If your client names are in a single column, say A, with what they spent
alongside in B then set up say in F1 a free cell where you can enter a name
in the list. Alongside this in G1 enter

=SUMIF(A:A,F1,B:B)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Sandhya" wrote in message
...
As i am running a business i have to deal with some clients who are
regular
with me.So for which i use excel to put in their data.So what i would like
is.....is it possible that i can type somewhere in that excel sheet and
check
for that particular client example suppose"Sandy" is my client.So i would
to
check how much of business(in terms of money) has sandy given me.
Is that possible to be made or please tell me which office product can be
used to do the same
Please help me

?B?U2FuZGh5YQ==?= wrote:

As i am running a business i have to deal with some clients who are
regular with me. So for which i use excel to put in their data. So what
i would like is.....is it possible that i can type somewhere in that
excel sheet and check for that particular client ...

Maybe the excel feature
Data Pivot Table Report ...
would meet your need.