View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nick Krill Nick Krill is offline
external usenet poster
 
Posts: 19
Default 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!