With the below data in Sheet1 , can you try the below formula

A2 to D6
Jan|Section1|SubSection1|20
Jan|Section1|SubSection1|20
Jan|Section1|SubSection1|10
Feb|Section1|SubSection1|20
Feb|Section1|SubSection1|20

=SUMPRODUCT((ISNUMBER(SEARCH("Jan",Sheet1!A2:A6,1) ))*ISNUMBER(SEARCH("SubSection1",Sheet1!C2:C6,1)), D2:D6)


If this post helps click Yes
---------------
Jacob Skaria


"AdrenalinR" wrote:

No it just gave me a value of 0.

"Jacob Skaria" wrote: