# try sumif criteria reference

1. ## try sumif criteria reference

Try
=SUMIF(B5:B47,"="&E5, C5:C47)

or
=SUMPRODUCT(--(B5:B47=E5),C5:C47)

--
Regards

Roger Govier

"TimH" <TimH@discussions.microsoft.com> wrote in message
news:5E916559-416A-46F3-BBE3-4B5E1A4735CC@microsoft.com...
> It seems like such a simple question. Range B5:C47 is a list of dates (in
> order, but some repeating) and a list of dollar amounts (deposits made on
> that day). I want to add up all the deposits on a given date. In column E
> I
> have a list of dates, in column F I want the sum of the corresponding
> date.
> So for example, in E5 I have the first date. In F5 I have this (which
> returns an error): SUMIF(B5:B47,"=E5", C5:C47). I want to return the sum
> of
> all deposits on the date in cell E5.

2. ## re: try sumif criteria reference

Not the 2nd, please.

Roger Govier wrote:
> Try
> =SUMIF(B5:B47,"="&E5, C5:C47)
>
> or
> =SUMPRODUCT(--(B5:B47=E5),C5:C47)
>

3. ## re: try sumif criteria reference

And why not, Aladin?

--
Regards

Roger Govier

"Aladin Akyurek" <akyurek@xs4all.nl> wrote in message
news:42f3ddf6\$0\$11069\$e4fe514c@news.xs4all.nl...
> Not the 2nd, please.
>
> Roger Govier wrote:
>> Try
>> =SUMIF(B5:B47,"="&E5, C5:C47)
>>
>> or
>> =SUMPRODUCT(--(B5:B47=E5),C5:C47)
>>

4. ## re: try sumif criteria reference

Awesome - you guys (girls?) rock!

"TimH" wrote:

> It seems like such a simple question. Range B5:C47 is a list of dates (in
> order, but some repeating) and a list of dollar amounts (deposits made on
> that day). I want to add up all the deposits on a given date. In column E I
> have a list of dates, in column F I want the sum of the corresponding date.
> So for example, in E5 I have the first date. In F5 I have this (which
> returns an error): SUMIF(B5:B47,"=E5", C5:C47). I want to return the sum of
> all deposits on the date in cell E5.

5. ## re: try sumif criteria reference

Because processing array objects takes more time than range objects.
Since SumIf does the latter and fits the task at hand (single-condition
summing), a SumIf formula would be better.

Roger Govier wrote:
> And why not, Aladin?
>

6. ## re: try sumif criteria reference

Try
=SUMIF(B5:B47,"="&E5, C5:C47)

or
=SUMPRODUCT(--(B5:B47=E5),C5:C47)

--
Regards

Roger Govier

"TimH" <TimH@discussions.microsoft.com> wrote in message
news:5E916559-416A-46F3-BBE3-4B5E1A4735CC@microsoft.com...
> It seems like such a simple question. Range B5:C47 is a list of dates (in
> order, but some repeating) and a list of dollar amounts (deposits made on
> that day). I want to add up all the deposits on a given date. In column E
> I
> have a list of dates, in column F I want the sum of the corresponding
> date.
> So for example, in E5 I have the first date. In F5 I have this (which
> returns an error): SUMIF(B5:B47,"=E5", C5:C47). I want to return the sum
> of
> all deposits on the date in cell E5.

7. ## re: try sumif criteria reference

Not the 2nd, please.

Roger Govier wrote:
> Try
> =SUMIF(B5:B47,"="&E5, C5:C47)
>
> or
> =SUMPRODUCT(--(B5:B47=E5),C5:C47)
>

8. ## re: try sumif criteria reference

And why not, Aladin?

--
Regards

Roger Govier

"Aladin Akyurek" <akyurek@xs4all.nl> wrote in message
news:42f3ddf6\$0\$11069\$e4fe514c@news.xs4all.nl...
> Not the 2nd, please.
>
> Roger Govier wrote:
>> Try
>> =SUMIF(B5:B47,"="&E5, C5:C47)
>>
>> or
>> =SUMPRODUCT(--(B5:B47=E5),C5:C47)
>>

9. ## re: try sumif criteria reference

Awesome - you guys (girls?) rock!

"TimH" wrote:

> It seems like such a simple question. Range B5:C47 is a list of dates (in
> order, but some repeating) and a list of dollar amounts (deposits made on
> that day). I want to add up all the deposits on a given date. In column E I
> have a list of dates, in column F I want the sum of the corresponding date.
> So for example, in E5 I have the first date. In F5 I have this (which
> returns an error): SUMIF(B5:B47,"=E5", C5:C47). I want to return the sum of
> all deposits on the date in cell E5.

10. ## re: try sumif criteria reference

Because processing array objects takes more time than range objects.
Since SumIf does the latter and fits the task at hand (single-condition
summing), a SumIf formula would be better.

Roger Govier wrote:
> And why not, Aladin?
>

11. ## sumif criteria reference

It seems like such a simple question. Range B5:C47 is a list of dates (in
order, but some repeating) and a list of dollar amounts (deposits made on
that day). I want to add up all the deposits on a given date. In column E I
have a list of dates, in column F I want the sum of the corresponding date.
So for example, in E5 I have the first date. In F5 I have this (which
returns an error): SUMIF(B5:B47,"=E5", C5:C47). I want to return the sum of
all deposits on the date in cell E5.

12. ## re: try sumif criteria reference

Try
=SUMIF(B5:B47,"="&E5, C5:C47)

or
=SUMPRODUCT(--(B5:B47=E5),C5:C47)

--
Regards

Roger Govier

"TimH" <TimH@discussions.microsoft.com> wrote in message
news:5E916559-416A-46F3-BBE3-4B5E1A4735CC@microsoft.com...
> It seems like such a simple question. Range B5:C47 is a list of dates (in
> order, but some repeating) and a list of dollar amounts (deposits made on
> that day). I want to add up all the deposits on a given date. In column E
> I
> have a list of dates, in column F I want the sum of the corresponding
> date.
> So for example, in E5 I have the first date. In F5 I have this (which
> returns an error): SUMIF(B5:B47,"=E5", C5:C47). I want to return the sum
> of
> all deposits on the date in cell E5.

13. ## re: try sumif criteria reference

Not the 2nd, please.

Roger Govier wrote:
> Try
> =SUMIF(B5:B47,"="&E5, C5:C47)
>
> or
> =SUMPRODUCT(--(B5:B47=E5),C5:C47)
>

14. ## re: try sumif criteria reference

And why not, Aladin?

--
Regards

Roger Govier

"Aladin Akyurek" <akyurek@xs4all.nl> wrote in message
news:42f3ddf6\$0\$11069\$e4fe514c@news.xs4all.nl...
> Not the 2nd, please.
>
> Roger Govier wrote:
>> Try
>> =SUMIF(B5:B47,"="&E5, C5:C47)
>>
>> or
>> =SUMPRODUCT(--(B5:B47=E5),C5:C47)
>>

15. ## re: try sumif criteria reference

Awesome - you guys (girls?) rock!

"TimH" wrote:

> It seems like such a simple question. Range B5:C47 is a list of dates (in
> order, but some repeating) and a list of dollar amounts (deposits made on
> that day). I want to add up all the deposits on a given date. In column E I
> have a list of dates, in column F I want the sum of the corresponding date.
> So for example, in E5 I have the first date. In F5 I have this (which
> returns an error): SUMIF(B5:B47,"=E5", C5:C47). I want to return the sum of
> all deposits on the date in cell E5.

16. ## re: try sumif criteria reference

Because processing array objects takes more time than range objects.
Since SumIf does the latter and fits the task at hand (single-condition
summing), a SumIf formula would be better.

Roger Govier wrote:
> And why not, Aladin?
>

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1