Results 1 to 3 of 3

Thread: IF a value is true in a number of cells

  1. #1

    Red face IF a value is true in a number of cells



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    See the added picture. I am trying to sum the column "Value" based on day and hour, example:

    if day=1 and hour=0 I want to sum every number in the column "value" that is containing that. Moving on to the next, day=1 and hour=1 and the total value of that.

    Any suggestions would be greatly appreciated!

    Thanks in advance and best wishes!
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	fråga2.JPG 
Views:	14 
Size:	76.2 KB 
ID:	4075  
    Last edited by Skrikarn; 2015-10-26 at 03:34 PM.

  2. #2
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    869
    Articles
    0
    Excel Version
    Excel 2013
    Quote Originally Posted by Skrikarn View Post
    I am trying to sum the column "Value" based on day and hour
    Try
    First
    Code:
    =SUMIFS(C2:C100;B2:B100;0;D2:D100;1)
    Second
    Code:
    =SUMIFS(C2:C100;B2:B100;1;D2:D100;1)
    Pay attention, you may need to use a comma separator instead of a semicolon
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

  3. #3
    Quote Originally Posted by navic View Post
    Try
    First
    Code:
    =SUMIFS(C2:C100;B2:B100;0;D2:D100;1)
    Second
    Code:
    =SUMIFS(C2:C100;B2:B100;1;D2:D100;1)
    Pay attention, you may need to use a comma separator instead of a semicolon
    Many thanks for the help, it solved it perfectly!!!!

Posting Permissions

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