LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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(D6:D41,"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 Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel still not recognising equal values pecan Excel Worksheet Functions 1 July 16th 08 10:40 AM
to check if the values in two sheets are equal SKP Excel Discussion (Misc queries) 1 November 29th 07 01:50 PM
Excel not recognizing equal values san-avsc Excel Worksheet Functions 5 November 3rd 06 10:19 PM
How to add equal values and than replace them with their sum? Sergiy G. Excel Worksheet Functions 0 September 7th 05 01:06 AM
list values equal in 2 worksheets? NEVA LOCKETT Excel Worksheet Functions 2 February 23rd 05 03:21 PM


All times are GMT +1. The time now is 07:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"