CODEWITHSUNDEEP
excel
Hotvivid
Hotvivid

Reputation: 1

Excel: sum a column by comparing dates in one column with a date in one cell

I have one column with dates, one column with values and one cell with date in excel. I want to see if the dates in the column is greater than the cell date if it is then sum up the values from another column

for eg. - sheet1 A:A has dates Sheet1 B:B has numbers Sheet 2 cell A has a date 02/02/2013

If cell A is greater than sheet1 A:A then sum Sheet 1 B:B in a seperate cell.

Thanks so much

Upvotes: 0

Views: 1666

Answers (2)

SeekingAlpha
SeekingAlpha

Reputation: 7817

You can fill out another column and enter this formula: 

=IF(A1>$C$1,B1,"")

and drag the formula down. What you will have in this new column is all the numbers of the dates that are greater then the date in cell C1.

You can then just sum up the column.

A bit hacky but it will do what you want.

NOTE: assuming that the given date is in cell C1. Could not tell from your question.

Upvotes: 0

Silenxor
Silenxor

Reputation: 244

=SUMIF(Sheet1!A:A,">"&Sheet2!A1,Sheet1!B:B)

This SUMIF formula will sum up all the values in sheet 1 column B where the value in sheet 1 column A are greater than the value in sheet 2 cell A1.

Upvotes: 0

Related Questions