+ Reply to Thread
Results 1 to 16 of 16

try sumif criteria reference

  1. #1
    Roger Govier
    Guest

    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. #2
    Aladin Akyurek
    Guest

    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. #3
    Roger Govier
    Guest

    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. #4
    TimH
    Guest

    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. #5
    Aladin Akyurek
    Guest

    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. #6
    Roger Govier
    Guest

    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. #7
    Aladin Akyurek
    Guest

    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. #8
    Roger Govier
    Guest

    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. #9
    TimH
    Guest

    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. #10
    Aladin Akyurek
    Guest

    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. #11
    TimH
    Guest

    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. #12
    Roger Govier
    Guest

    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. #13
    Aladin Akyurek
    Guest

    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. #14
    Roger Govier
    Guest

    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. #15
    TimH
    Guest

    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. #16
    Aladin Akyurek
    Guest

    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?
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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