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