Help with SUMIF formula

LordEvil

New Member
Joined
Oct 20, 2018
Messages
16
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.
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
right direction?

sure, post representative example of your source data and expected result (or link to the shared excel file)
 
Upvote 0
Try
=SUMIFS(Sheet2!H2:H20000,Sheet2!D2:D20000,I1,Sheet2!E2:E20000,J1)
 
Upvote 0
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)
 
Last edited:
Upvote 0
Glad it's working & thanks for the feedback
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,207
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top