Share via

Extract monthly data by date

Anonymous
2013-07-16T01:01:00+00:00

I have an excel spreadsheet with raw data for each days of the week.  I would like to extract the data from a certain date into a report.  I would like to make it fluid, so all I need to enter 10, for example, and the data from the 10th would populate the report.  How do I write a formula in the Report cells to do this?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2013-07-16T01:32:07+00:00

You could use SUMIFS, COUNTIFS and AVERAGEIFS.

Let's say your date is in A1, you have dates in column C and amounts related in column D.

=sumifs(D:D, C:C, $a$1)

will give you the sum of values in column D when column C matches A1.

You could use SUMIF instead of SUMIFS, but the former is a lot more powerful, and you would only have to learn the sintaxis for one of them.

Was this answer helpful?

0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest