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: 15
Default How to add time from multiple cells & date Cells & machine type c

I'm trying to add up the amount of machinery downtime from a number of
different cells but the thing is that I need to only have it added up by the
date set in another cell (Which can have multiple cells of the same date) as
well as the specific name of that machinery in another cell(which can also
have multiples of the same machinery name). How can i get to just add up for
that specific date, machine name, and time.

Example:

Date (Cell 1A thru 50A) Machinery Name(Cell 1B thru 50B) Downtime(Cell 1J
thru 50J)

Please help
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
Counting&Sorting multiple serial numbers per machine type Dark_Templar Excel Discussion (Misc queries) 5 June 17th 06 09:06 AM
Date and time stamping multiple cells for multiple entries. Gerald Excel Worksheet Functions 1 May 9th 06 01:45 PM
Reference & update destin. cells on 1st machine from source workbook on 2nd machine. [email protected] Excel Discussion (Misc queries) 6 February 28th 06 05:15 AM
Convert data type of cells to Text,Number,Date and Time Kevin Excel Worksheet Functions 1 December 31st 04 12:57 PM
Convert data of cells to any type: Number, Date&Time, Text Kevin Excel Discussion (Misc queries) 0 December 30th 04 06:55 AM


All times are GMT +1. The time now is 03:14 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"