Hi,

Could you show us how the data is arranged and what the data is exactly

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"MrRJ" wrote in message
...
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