excel formatting
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 , JeffDamin 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 , "Rodney" 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. |
All times are GMT +1. The time now is 09:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com