| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum/Count Multiple columns
Help!
I'm trying to get a formula that will work out the following, without inserting any new columns on sheets I'm looking at. I Need to Sum and count when Column B = "Ongoing" Column D = (This is variour different types of customer) The column I need totalled is Column K. It also needs counting so I can work out what the average order interval is. I can get it to work if I add another column which uses B&D, together. But Ideal I want a sep formula to work it out. Any Ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| using functions to compare multiple columns for mismatch of cells | Excel Worksheet Functions | |||
| making multiple columns when printing long datasheet | Excel Discussion (Misc queries) | |||
| Justify text across multiple columns | Excel Discussion (Misc queries) | |||
| Pivot Table combining multiple columns | Excel Discussion (Misc queries) | |||
| HOW TO MATCH MULTIPLE COLUMNS WITH OR WITHOUT GAPS IN eXCEL ? | Excel Worksheet Functions | |||
Threaded Mode
