sum data up to a specific date?

**shiftyspina** · 03-06-2014, 08:49 AM

Hi All

Is there a way to sum data up to a specific date?

I have a large data table, which includes various values throughout the year, if i want to look at the total value up until say 31/01/2014, but my data goes up to 28/02/2014, is there way to do this within the sumifs function?

Thanks

Dan

**satabp** · 03-06-2014, 09:08 AM

Hi,

Try this array formula...

=SUMPRODUCT(--IF(A:A<=DATE(2014,1,31),C:C,0))

**satabp** · 03-06-2014, 09:11 AM

Or also the following normal formula..

=SUMPRODUCT((A:A<=DATE(2014,1,31))*(C:C))

**shiftyspina** · 03-06-2014, 10:13 AM

Perfect thank you

sum data up to a specific date?

LinkBack

Thread Tools

Rate This Thread

Display

sum data up to a specific date?

Re: sum data up to a specific date?

Re: sum data up to a specific date?

Re: sum data up to a specific date?

Thread Information

Users Browsing this Thread

Similar Threads

Compound interest calculation from one specific date to another specific date.

Looking up data from a specific date

[SOLVED] Lookup Specific Date from a List of Date Ranges & Return Related Data

import data from txt to excel starting from a specific date to other date

Automatically send an email from excel with specific data on specific date.

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions