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!
|