Multiple Data To Retun Single value Help Req

Curdster

New Member
Joined
Jan 30, 2014
Messages
3
Can any one help here. I think I need to link different formulas here and don't want to use a pivot table. The columns run to row 200 and I have 10 separate spreadsheets. I want to create a new file, a master consolidated view

Each row represents 1 client

Column A Contains Yes or No
Column B Contains the Source (i.e Post, Email, Phone)
Column C contains a range of different dates ie when customer made contact
Column D Contains a currency value.

So the question I need to answer is; Return a sum of Column D for those values who's row attributes are Yes, Post and date of current day +5.

In simple terms who can I contact in 5 days time and what is the expected value.

I have added current date in cell E1. F1, F2, F3, contains text Post, Email, Phone.

Can anyone help me?I have been a this for days I think I am confusing myself.
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
Hi - welcome to the board.

Depending on what you mean by "date of current day +5", perhaps:

=sumproduct(--(a2:a200="Yes"),--(b2:b200="Post"),--(c2:c200>=today()+5),d2:d200)
 

Curdster

New Member
Joined
Jan 30, 2014
Messages
3
Paddy this is superb. Thank you. Can you tell me how change the date part of the formula so that it returns values which are always within the next 5 days not greater than equal to or less than. i.e if today is 01/02/2014, it would return the sum of values where dates are, 01/02/2014, 02/02/2014, 03/02/2014, 04/02/2014, 05/02/2014.
 

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
=sumproduct(--(a2:a200="Yes"),--(b2:b200="Post"),--(c2:c200>=today()),--(c2:c200< =today()+5),d2:d200)
 

Watch MrExcel Video

Forum statistics

Threads
1,122,514
Messages
5,596,610
Members
414,080
Latest member
penguin23

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
Top