I'm not quite sure of your data layout from your description (is column S on
the Data sheet numbers or month names or ??), but I found if I added a helper
Sum column (W, in my example) it was easy to write a SumProduct formula that
works:

=SUMPRODUCT(--(Data!$K$3:$K$241=Summary!A8),--(Data!$S$3:$S$241=Summary!C5),Data!$W$3:$W$241)

You will need to adjust the cell references. If you can describe your data
layout in more detail, I will be glad to help.

Hope this helps,

Hutch

"phonemanager" wrote:

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