sumifs help needed

[politicalangel]

Does anyone know a fomula I can use to populate sheet4?
I ae thousands of lins of data in the other sheet and would like to summarize whats been cleared on a weekly basis at a certain point/between this certain points in in time when the checks clear.

Summary( Sheet 4)
Payments NA EMEA
1/6/2014
1/13/2014
1/20/2014
2/1/2014
NA ( sheet 1)
Checks Issued Amount date Payee
5293460 120.4 1/11/2014 Jan Doe
5293580 419.18 1/20/2014 Marc Ant
5392314 26.13 1/1/2014 John Doe
EMEA ( Sheet 2)
Checks Issued Amount date Payee
6110000 200 1/11/2014 Jan Doe
5232193 300 1/20/2014 Marc Ant
5392314 400 1/1/2014 John Doe
5300000 100 2/1/2014 Kevin A
Cleared ( Sheet 3)
Checks Issued Amount
6110000 200 1/20/2014
5232193 300 1/21/2014
5293460 400 1/12/2014
5392314 26.13 1/6/2014

 

[Debraj]

Hi politicalangel!

Welcome to the forum,

Without seeing the stricture of the file.. here is a blind guess.
In Sheet4, B2 use formula as
=SUMIF(INDIRECT("'"&B$1&"'!c1:C100"),$A2,INDIRECT("'"&B$1&"'!B1:B100"))

​

politicalangel​

​

politicalangel​

 

[politicalangel]

Atatced is a sample of what am tryin to calculate on my summary tab

 

[SirJB7]

Hi, politicalangel!

As a new user you might want to (I'd say should and must) read this:
http://chandoo.org/forum/forums/new-users-please-start-here.14/

And regarding your issue, could you post which values do you expect in yellow range B2:C5 of worksheet Summary? That will help contributors to check their suggested models.

Regards!

 

[Debraj]

Hi, politicalangel!

Can you please check the attached, if this is what you are looking for.