| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need Help Formulating a spreadsheet
Hi
Example of spreadsheet A B Product Count 1 lemons 9 2 apples 5 3 lemons 12 4 pears 2 I have a spreadsheet with a large amount of products with counts I need to sort the product that are the same and add up the counts if anyone can give me a formula it would be great |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need Help Formulating a spreadsheet
If "lemons" is in C1, try
=Sumif(A1:A4, C1, B1:B4) "Greg" wrote: Hi Example of spreadsheet A B Product Count 1 lemons 9 2 apples 5 3 lemons 12 4 pears 2 I have a spreadsheet with a large amount of products with counts I need to sort the product that are the same and add up the counts if anyone can give me a formula it would be great |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need Help Formulating a spreadsheet
Try a pivot table it will summarize the data for you.
The other was is to sort and use subtotals. -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "JMB" wrote: If "lemons" is in C1, try =Sumif(A1:A4, C1, B1:B4) "Greg" wrote: Hi Example of spreadsheet A B Product Count 1 lemons 9 2 apples 5 3 lemons 12 4 pears 2 I have a spreadsheet with a large amount of products with counts I need to sort the product that are the same and add up the counts if anyone can give me a formula it would be great |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need Help Formulating a spreadsheet
For the pivot table:
In the pivot table put product in the row area on the left and count in the data area (on the right at the bottom) and make sure it says sum of count. Then it should work. -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "Greg" wrote: I need to merge the products and add the counts I could have been me but both these just sorted my data "Martin Fishlock" wrote: Try a pivot table it will summarize the data for you. The other was is to sort and use subtotals. -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "JMB" wrote: If "lemons" is in C1, try =Sumif(A1:A4, C1, B1:B4) "Greg" wrote: Hi Example of spreadsheet A B Product Count 1 lemons 9 2 apples 5 3 lemons 12 4 pears 2 I have a spreadsheet with a large amount of products with counts I need to sort the product that are the same and add up the counts if anyone can give me a formula it would be great |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulating cells | Excel Worksheet Functions | |||
| Formulating between worksksheets | Excel Discussion (Misc queries) | |||
| Need help on formulating ordering | Excel Worksheet Functions | |||
| conditional formulating | Excel Discussion (Misc queries) | |||
| formulating if; then; enter list | Excel Worksheet Functions | |||
Linear Mode
