LinkBack URL
About LinkBacks
I have columns that contain text (Populated from drop down lists). I need to be able to sum the totals of each type from the drop down list. These totals can either be displayed on a second sheet, any ideas?
I have columns that contain text (Populated from drop down lists). I need to be able to sum the totals of each type from the drop down list. These totals can either be displayed on a second sheet, any ideas?
Last edited by wejims; 06-16-2009 at 04:53 PM.
Which column are you summing? There are no values in any columns... as I can see.
Also, What is the summing/counting going to be based on?
Last edited by NBVC; 06-16-2009 at 01:53 PM.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
There's a dropdown in B2 is that the one you mean? So if I select "Suffolk" from the list for example, what needs to be summed?
Sorry, I was kind of vague. The final result would be to determine the total number of stores (Column A) by type of delivery (Column D). So The stores on distributor pallet would need to be separated from let's say rollers and stands and than the totla number of stores would need to be displayed as a whole number, ie... 12 stores on distributor pallet, 18 stores on rollers stands etc. Hope that helps.
Maybe just a simple Pivot Table as per attached in Sheet4?
To get that table.
select Data|Pivot table...
Click Next
Select (verify) range (including headers)
Click Next
Click Layout
Drag Delivery Methodology (Dry) to the Rows Area
Drag Store # to the Data Area.. should default to Count (if not, double-click the dragged item and choose Count).
Thanks for the help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks