Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a small work book, tracks deliveries made and trucks used.
I have seven sheets Saturday thru Friday and one sheet that totals everything up! The weekly sheets have 34 rows representing 34 stores that we service and the total sheet also has 34 rows that contain the totals for that week. Here is my question I am trying to, on the totals sheet, sum up the total trucks that we used per store per week. In the cell would be entered 0, 0.5, 1, 2 and so on depending on how many trucks we used for that day. Yes we use 0.5 if the store was combo'ed with another store. I need to have a count of the cells that are greater than 0 or "0" I don't need a sum just need to know that we used a truck so I would need a count on the cells that are greater then 0... Countif works on just one sheet and I can't find a solution to this... if someone with more experience to just direct me in the right direction... -- thanks for your help Dave |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007: Can it SUMIF( ) using color as a condition ? | Excel Discussion (Misc queries) | |||
condition sumif commands based on date range? | Excel Discussion (Misc queries) | |||
Sum across sheets based on a condition | Excel Worksheet Functions | |||
Referencing Across Sheets Based On Condition | Excel Worksheet Functions | |||
Is it possible to specify multiple condition with SUMIF? | Excel Worksheet Functions |