i have a spreadsheet that lists by salesman po's and their value. how do i
create a formula so that i can add all the rows just for a particular
salesman. i do have the drop down list on the salesman header.
i have a spreadsheet that lists by salesman po's and their value. how do i
create a formula so that i can add all the rows just for a particular
salesman. i do have the drop down list on the salesman header.
One way:
=SUMIF(A:A,"Joe",B:B)
if you want to do this for all of your salesmen, this is a perfect
application for a Pivot Table:
http://peltiertech.com/Excel/Pivots/pivotstart.htm
In article <[email protected]>,
JeffDamin <[email protected]> wrote:
> i have a spreadsheet that lists by salesman po's and their value. how do i
> create a formula so that i can add all the rows just for a particular
> salesman. i do have the drop down list on the salesman header.
Thankyou very much for this link,
It has been on my agenda for some time.
I am apprehensive, and have feelings akin to
my first leap into space from the 7 metre diving board
when I was a kid.
| if you want to do this for all of your salesmen, this is a perfect
| application for a Pivot Table:
|
| http://peltiertech.com/Excel/Pivots/pivotstart.htm
|
I suspect, like after your first dive, you'll wonder why you were
apprehensive after you play with the PT for a while.
In article <#[email protected]>,
"Rodney" <[email protected]> wrote:
> I am apprehensive, and have feelings akin to
> my first leap into space from the 7 metre diving board
> when I was a kid.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks