Help with SUMIF formula

[LordEvil]

Hi everyone,

I've tried reading a lot of articles in excel support with no luck. I am trying to do a sumif formula but i keep getting a zero when there is clearly data to be calculated.

I have two pages
I am trying to calculate the field on sheet2 column $H2:$H20000
The cells need to look for matching data from Sheet1 cells I1 and J1 and put the total in L1
It has to find the data that matches in sheet2 columns D2:D20000 and E2:E20000
Sheet1, I1 will be somewhere in sheet2 D2:D20000
Sheet1, J1 will be somewhere in sheet2 E2:E20000

The formula I can't figure out but tried using is
SUMIF(Sheet1!D:E,I3:J3,Sheet1!H2:H20000)

Thanks for any help or steer me in the right direction.

 

[sandy666]

right direction?

sure, post representative example of your source data and expected result (or link to the shared excel file)

 

[Fluff]

Try
=SUMIFS(Sheet2!H2:H20000,Sheet2!D2:D20000,I1,Sheet2!E2:E20000,J1)

 

[LordEvil]

This ended up working which is weird because it is almost the same formula, just removed the specific cell set of 2 : 20000.
=SUMIFS(Sheet2!H:H,Sheet2!D:D,I1,Sheet2!E:E,J1)

 

[Fluff]

Glad it's working & thanks for the feedback