Comparing, Matching, and Sum formula
 

Hello.

Column A has dates. The format is 2010-04-29. There are multiple rows with
the same date.

Column B has numbers

Please, provide me the formula IF:

column A="2010-04-29" then SUM(B:B)

Thank you.

Comparing, Matching, and Sum formula
 

=IF(A1=DATE(2010,4,29),SUM(B:B),0)



--
Regards
Dave Hawley
www.ozgrid.com
"ma" wrote in message
...
Hello.

Column A has dates. The format is 2010-04-29. There are multiple rows with
the same date.

Column B has numbers

Please, provide me the formula IF:

column A="2010-04-29" then SUM(B:B)

Thank you.

Comparing, Matching, and Sum formula
 

Thank you for your response.

How would I modify it so that it only summed column B so as long as Date=
2010,4,29 in any row of column A. Right now it's summing all of column B even
when the date changes.

"ozgrid.com" wrote:

=IF(A1=DATE(2010,4,29),SUM(B:B),0)



--
Regards
Dave Hawley
www.ozgrid.com
"ma" wrote in message
...
Hello.

Column A has dates. The format is 2010-04-29. There are multiple rows with
the same date.

Column B has numbers

Please, provide me the formula IF:

column A="2010-04-29" then SUM(B:B)

Thank you.

Comparing, Matching, and Sum formula
 

I appreciate your response.

Could you tell me how I would modify this so that it only sums what is B so
as long as the DATE is 2010,4,29 in column A? Currently, it is summing the
whole column even when the date changes. Example:

2010-04-29 2
2010-04-29 7
2010-04-29 1
2010-04-28 4
2010-04-28 3

Results:
10
7


"ozgrid.com" wrote:

=IF(A1=DATE(2010,4,29),SUM(B:B),0)



--
Regards
Dave Hawley
www.ozgrid.com
"ma" wrote in message
...
Hello.

Column A has dates. The format is 2010-04-29. There are multiple rows with
the same date.

Column B has numbers

Please, provide me the formula IF:

column A="2010-04-29" then SUM(B:B)

Thank you.

Comparing, Matching, and Sum formula
 

Try this...

=SUMIF(A:A,DATE(2010,4,29),B:B)

Better to use a cell to hold the date

D1 = 4/29/2010

=SUMIF(A:A,D1,B:B)

--
Biff
Microsoft Excel MVP


"ma" wrote in message
...
Thank you for your response.

How would I modify it so that it only summed column B so as long as Date=
2010,4,29 in any row of column A. Right now it's summing all of column B
even
when the date changes.

"ozgrid.com" wrote:

=IF(A1=DATE(2010,4,29),SUM(B:B),0)



--
Regards
Dave Hawley
www.ozgrid.com
"ma" wrote in message
...
Hello.

Column A has dates. The format is 2010-04-29. There are multiple rows
with
the same date.

Column B has numbers

Please, provide me the formula IF:

column A="2010-04-29" then SUM(B:B)

Thank you.

Comparing, Matching, and Sum formula
 

Thank you. I went with the second formula and it worked!

"T. Valko" wrote:

Try this...

=SUMIF(A:A,DATE(2010,4,29),B:B)

Better to use a cell to hold the date

D1 = 4/29/2010

=SUMIF(A:A,D1,B:B)

--
Biff
Microsoft Excel MVP


"ma" wrote in message
...
Thank you for your response.

How would I modify it so that it only summed column B so as long as Date=
2010,4,29 in any row of column A. Right now it's summing all of column B
even
when the date changes.

"ozgrid.com" wrote:

=IF(A1=DATE(2010,4,29),SUM(B:B),0)



--
Regards
Dave Hawley
www.ozgrid.com
"ma" wrote in message
...
Hello.

Column A has dates. The format is 2010-04-29. There are multiple rows
with
the same date.

Column B has numbers

Please, provide me the formula IF:

column A="2010-04-29" then SUM(B:B)

Thank you.



.

Comparing, Matching, and Sum formula
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"ma" wrote in message
...
Thank you. I went with the second formula and it worked!

"T. Valko" wrote:

Try this...

=SUMIF(A:A,DATE(2010,4,29),B:B)

Better to use a cell to hold the date

D1 = 4/29/2010

=SUMIF(A:A,D1,B:B)

--
Biff
Microsoft Excel MVP


"ma" wrote in message
...
Thank you for your response.

How would I modify it so that it only summed column B so as long as
Date=
2010,4,29 in any row of column A. Right now it's summing all of column
B
even
when the date changes.

"ozgrid.com" wrote:

=IF(A1=DATE(2010,4,29),SUM(B:B),0)



--
Regards
Dave Hawley
www.ozgrid.com
"ma" wrote in message
...
Hello.

Column A has dates. The format is 2010-04-29. There are multiple
rows
with
the same date.

Column B has numbers

Please, provide me the formula IF:

column A="2010-04-29" then SUM(B:B)

Thank you.



.