View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
phonemanager phonemanager is offline
external usenet poster
 
Posts: 3
Default Need a formula to sum with conditions

I am trying to create a summary of data contained in a second worksheet in a
workbook.
I need to sum the dollar amouts of Columns S2:V241 but only if the amounts
appear in a designated month under the supervisor's name.

S5= January (on Data tab), C5= January (on Summary tab)
K3:K241 = Supervisor's name (on Data tab), A8:A24 = Supervisor's name (on
Summary tab)
I have been playing with sumproduct formulas for 2 days now (lol) but just
don't have enough experience with this type of formula and can't seem to make
it work.
Any help/suggestions woud be greatly appreciated!
Thank you in advance!
--
Will this ever be easy??