Sum Product Not Working

Maybe I'm using the wrong type of formula.

But what I need here is the calculation of summing every time a column has a certain year & month.

For example, in the file attached you'll see column A is the year. Column C is the month. Column D is what I used to add up visits to the gym. So in my recap I have it laid out showing each year vertically & each month horizontally. This allows me to have a recap in a table form. So every time 2008 & July show up sum the visits (from column D).

Thanks

Try this.

=SUMPRODUCT(--(Workingout!A$1:A$65536=WoutRecap!$A22),--(Workingout!C$1:C$65536=WoutRecap!B$21),(Workingout!D$1:D$65536))

Originally Posted by Norie

=SUMPRODUCT(--(Workingout!A$1:A$65536=WoutRecap!$A22),--(Workingout!C$1:C$65536=WoutRecap!B$21),(Workingout!D$1:D$65536))

SUMIFS would be more efficient...

=SUMIFS(Workingout!D:D,Workingout!A:A,WoutRecap!$A22,Workingout!C:C,WoutRecap!B$21)

You're welcome. Thanks for the feedback!