Is this Possible with excel

S

Sandhya

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
 
N

Nick Hodge

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
[email protected]
 
J

Jay

=?Utf-8?B?U2FuZGh5YQ==?= said:
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 ...
Click to expand...

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