Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sums with conditions and multiple columns
I am trying to create a sum of the quantities in the cells based upon
conditions. This is the layout of my spreadsheet: Column A B C D E F Title Client no. Total Air Ocean Ground Employee What I would like to do is count the totals of each mode of transport by Rater. So for example I need to count the totals of all of the clients serviced a certain employee. Could you please help me create the proper formula to acheive this. Thank you, Claire |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sums with conditions and multiple columns
Rather than a formula, it sounds like a Pivot Table would be better for
your purpose: http://peltiertech.com/Excel/Pivots/pivottables.htm In article , Claire wrote: I am trying to create a sum of the quantities in the cells based upon conditions. This is the layout of my spreadsheet: Column A B C D E F Title Client no. Total Air Ocean Ground Employee What I would like to do is count the totals of each mode of transport by Rater. So for example I need to count the totals of all of the clients serviced a certain employee. Could you please help me create the proper formula to acheive this. Thank you, Claire |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting rows that meet conditions in multiple columns | Excel Worksheet Functions | |||
Countif depending on the conditions across multiple columns | Excel Worksheet Functions | |||
sums with several conditions | Excel Worksheet Functions | |||
Sums and columns | Excel Discussion (Misc queries) | |||
SumIF full columns, multiple conditions | Excel Discussion (Misc queries) |