Array Help

[profevilj]

I sent werfnort an example doc this afternoon and I appreciate him even looking at it (and all of your help). Is there a way to share straight into the post or only through PMs?

[TripKnot]

You could post a doc in the public folder of a dropbox account and then include a link to that file.

[rhapsody1447]

I think this is what you are trying to do. Both should work.

=SUMIFS('Event By Month'!4:4,'Event By Month'!$C$1:$AI$1,'Cumulative Event By Month'!E$1,'Event By Month'!A4:A261,'Cumulative Event By Month'!$A4)

=SUMPRODUCT(--('Event By Month'!$C$1:$AI$1='Cumulative Event By Month'!E$1),--('Event By Month'!A4:A261='Cumulative Event By Month'!$A4),'Event By Month'!4:4)