If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Add different values that equal 1 on a row
I am trying to add how many seat hours per equipment type each person has.
Which formula should I use? I've tried several and I get errors. Example: Crane type 3&4: how many times they have used this type of crane. I used this formula but get 0 value instead of "3", which is the number of times in the selection that the person used this specific type of equipment. =SUMIF(D641,"if(d6:d41{=3},{=4},1") I am trying to assign a value of 1 to each cell that has a 3 or a 4 in it in that specific range, so that when I add the range it will calculate how many times they used either crane #3 or crane #4. Thanks |
#2
|
|||
|
|||
Add different values that equal 1 on a row
Maybe one way:
=COUNTIF(D641,3)+COUNTIF(D641,4) HTH, Paul -- "Add sum of different values" Add sum of different wrote in message ... I am trying to add how many seat hours per equipment type each person has. Which formula should I use? I've tried several and I get errors. Example: Crane type 3&4: how many times they have used this type of crane. I used this formula but get 0 value instead of "3", which is the number of times in the selection that the person used this specific type of equipment. =SUMIF(D641,"if(d6:d41{=3},{=4},1") I am trying to assign a value of 1 to each cell that has a 3 or a 4 in it in that specific range, so that when I add the range it will calculate how many times they used either crane #3 or crane #4. Thanks |
#3
|
|||
|
|||
Add different values that equal 1 on a row
Try:
=SUMPRODUCT(--(D641={3,4})) -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Add sum of different values" Add sum of different wrote in message ... I am trying to add how many seat hours per equipment type each person has. Which formula should I use? I've tried several and I get errors. Example: Crane type 3&4: how many times they have used this type of crane. I used this formula but get 0 value instead of "3", which is the number of times in the selection that the person used this specific type of equipment. =SUMIF(D641,"if(d6:d41{=3},{=4},1") I am trying to assign a value of 1 to each cell that has a 3 or a 4 in it in that specific range, so that when I add the range it will calculate how many times they used either crane #3 or crane #4. Thanks |
Thread Tools | |
Display Modes | |
|
|