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.

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



--
Regards
Dave Hawley
www.ozgrid.com
"ma" <(E-Mail Removed)> wrote in message
news:77545BE3-1CAC-48BF-B407-(E-Mail Removed)...
> 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.

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" <(E-Mail Removed)> wrote in message
> news:77545BE3-1CAC-48BF-B407-(E-Mail Removed)...
> > 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.
>

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" <(E-Mail Removed)> wrote in message
> news:77545BE3-1CAC-48BF-B407-(E-Mail Removed)...
> > 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.
>

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" <(E-Mail Removed)> wrote in message
news:380FE658-0C30-4F4E-A3AE-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:77545BE3-1CAC-48BF-B407-(E-Mail Removed)...
>> > 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.
>>

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" <(E-Mail Removed)> wrote in message
> news:380FE658-0C30-4F4E-A3AE-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
> >> news:77545BE3-1CAC-48BF-B407-(E-Mail Removed)...
> >> > 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.
> >>
>
>
> .
>

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"ma" <(E-Mail Removed)> wrote in message
news:0DBC0ACE-B254-41B4-9F90-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:380FE658-0C30-4F4E-A3AE-(E-Mail Removed)...
>> > 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" <(E-Mail Removed)> wrote in message
>> >> news:77545BE3-1CAC-48BF-B407-(E-Mail Removed)...
>> >> > 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.
>> >>
>>
>>
>> .
>>