Function date range specific cells if & date formula?

Closed
cfinck
Posts
3
Registration date
Friday July 29, 2016
Status
Member
Last seen
July 29, 2016
- Jul 29, 2016 at 09:31 AM
cfinck
Posts
3
Registration date
Friday July 29, 2016
Status
Member
Last seen
July 29, 2016
- Jul 29, 2016 at 12:01 PM
I need to be able to pull data(other cells in the row) from a specific date range.

My current formulas still need to be expressed but I only need it from certain dates so I can accumulate the data from a range.

Example: the date range is 5/1/2016 to 5/31/2016
Row DP4 : DP69

The first formula is
=iferror(c4/b4,0)

2nd
=if(b4,((b4-c4)/b4),0)

3rd
=iferror=(d4/b4,0)

4th
=if(b4,((c4+d4)/b4),0)

I keep trying to see how I can make this possible but I can't seem to get it. Any help would be appreciated.

Thank you.

2 replies

Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
147
Jul 29, 2016 at 10:11 AM
cfinck, Good morning.

Sorry, I'm not understanding your necessity and your layout.

Please, save your file at a free site, www.speedyshare.com, and put link here to download.

Display there your desired results.

It will be easier for us to help you conclusively.
0
cfinck
Posts
3
Registration date
Friday July 29, 2016
Status
Member
Last seen
July 29, 2016

Jul 29, 2016 at 10:47 AM
Thanks. Here's a mock up of my data.

http://speedy.sh/z8eQ8/Form.xlsx

I need to pull only the date with these formulas in a specific date range, so only May 2016 and only June, ect. But when I try to use the date function with a range of cells for that date range, I get an error .

Thank you so much for your help.
0
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
147
Jul 29, 2016 at 11:50 AM
cfinck, Good afternoon.

Thanks for example.

Still could not understand your need.
The sheet is filled with formulas and all of them are working.

Please, enter manually with the data the way they should appear on your expected outcome.
Give us a practical example.

Remember that you have total command over the knowledge of the data.
We're just trying to help you use Excel functions for you to succeed in your job.
I hope you understand our request.

Have a nice day.
0
cfinck
Posts
3
Registration date
Friday July 29, 2016
Status
Member
Last seen
July 29, 2016

Jul 29, 2016 at 12:01 PM
Hi,

I'm sorry about that. I am pulling data from all the cells in my workbook currently. I need to be more specific on which cells are included (by monthly date range). I need to have the formulas I am currently using but only for the rows with dates for a month. My working spreadsheet has 4000 rows.

Using the sort and filter option does not help me because I need the calculations to only pull per month as opposed to over all.

I remember being able to pull data from rows with certain dates and excluding all others but I can't get my formula to incorporate the date & if or if error functions properly.

What I tried is
=if((date>05/01/16,date<05/31/16,d2:d6,0)b4((c4+d4))/b4,0)

So I have not been able to ask the spreadsheet to only pull data from the rows within the month date range I selected.
0