# Posts by abba92

• ## Conditional Summing With Criteria

Re: Conditional Summing With Criteria

Thank you so much, Wigi! It works great!

• ## Conditional Summing With Criteria

I have a workbook that allows employees to enter a range of sizes ("casepack") and they can then assign the number of units per size. They can have up to 6 "casepacks" per workbook.

For example, in Rows 2-7 they can name their casepack a letter (A through F) and then assign sizes in those rows.
In Rows 10 through 103 they can enter the number of units per size they wish to order.
On a different worksheet, I want to total all the units by size.

I've attached the workbook to clarify. I'm rather stumped. Any help would be appreciated. A formula or macro would help.

• ## Calculating Time Based on Time Per Item

Re: Calculating Time Based on Time Per Item

Please disregard. I found the solution. I need to format my cells to be [h]:mm;@ to prevent the 24 hour rollover (it seems that if the time extended past 24 hours, it was an issue).

• ## Calculating Time Based on Time Per Item

Hi ~

I'd appreciate any help. I have a spreadsheet that has the number of used books in column A and the number of new books in column B.

We've determined that it takes about 90 seconds to prepare a book to be put on the shelves.

I want to find out how many hours and minutes (don't care about seconds) it would take to process the books.

Here's an emample. I've also attached a spreadsheet so you can see that my formula doesn't seem to work correctly. I would appreciate ANY help since I'm kind of at my wit's end. I'm using Excel 2003.

 # Used Books # New Books Hours/Minutes for Used Hours/Minutes for New 3,915 566 The formula I have in here is "=IF(A2=0,"",((A2)*90)/(60*60*24))" The formula I have in here is "=IF(B2=0,"",((B2)*90)/(60*60*24))" 3,703 474 2,076 238