Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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?? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
two conditions formula | Excel Discussion (Misc queries) | |||
IF formula for 3 possible conditions | Excel Discussion (Misc queries) | |||
Formula With Several Conditions | Excel Worksheet Functions | |||
If formula with 12 conditions | Excel Discussion (Misc queries) | |||
Help for a formula using two conditions | Excel Worksheet Functions |