Hello,

I produced a formula that I need to have expanded.
=SUM('2010 Actuals'!E2:INDEX('2010 Actuals'!E2:Q2,MATCH(Sheet1!C5,'2010
Actuals'!E1:Q1,0)))

I would like to do another condition based on my Category (E). It needs to
sum all values in the given Category. As you can see, I have one condition
for Period, which is C5.

I somehow see the use of Sumproduct formula, but cannot visualize it.

Can you please assist. Thanks