| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct to find monthly bonuses
I apologize for not being more elaborate in my initial query: How can I use
sumproduct on the last 30 rows of a database whose number of rows changes daily? My database has a list of first names in column A and sales results in column C. To compute monthly commission bonuses I need to multiply all those instances where column A = €œBob€ x all those same row instances where column C is greater than $850 It has me vexed! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to find each day prior to first friday, monthly | Excel Worksheet Functions | |||
| How to find how much to put aside monthly to reach savings goal | Excel Worksheet Functions | |||
| need to work out bonuses | Excel Worksheet Functions | |||
| I have a list of numbers (bus miles) I want to find the monthly a. | Excel Discussion (Misc queries) | |||
| Bonuses and Penalties in Grade Books | Excel Worksheet Functions | |||
Threaded Mode
