Using Dates within Excel Sumif

Posted by 2031387 PM | on Sun, 25/12/2005 - 01:01 34107 8 comments | report

Can anyone help with the following:

I have a column of dates with numbers in the next column. I wish to add all of the numbers which have a date greater than my conditional date.

The formula follows the logic:
Sumif(Column1,>conditional date,Column2).
The conditional date and calculation are being performed wihtin another workbook if this makes a difference!

Formula works if I replace the conditional date with an actual number but that isn't where I need to be.

Any help is gratefully appreciated.

Lynne Alden

Comments

There are 8 comments. Login or register to view them.

SUMIF

mikerees | Wed, 07/07/2004 - 13:25

Use DSUM with appropriately placed criteria range

malong | Wed, 07/07/2004 - 13:52

Conditional date is not a constant

2031387 | Wed, 07/07/2004 - 13:35

Sumif second argument

lynamn | Thu, 08/07/2004 - 17:05

Several ways to crack a nut.

AnonymousUser | Wed, 07/07/2004 - 17:58

Cool array, Adam?

AnonymousUser | Fri, 09/07/2004 - 13:03

Arrays in Excel

AnonymousUser | Thu, 08/07/2004 - 17:02

today() function with sumif function

dwpbhaskar | Tue, 04/12/2012 - 05:18