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