Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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 | |
#4
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel conditional formatting error | Excel Discussion (Misc queries) | |||
Excel could not save all the data and formatting you recently ad.. | Excel Worksheet Functions | |||
Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions | |||
Lotus 123 save as excel workbook and maintain formatting? | Excel Discussion (Misc queries) | |||
Lotus 123 save as excel workbook and maintain formatting? | Excel Discussion (Misc queries) |