Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculating populated fields from multiple workbooks
Hi
I have weekly reports and then a monthly report every month. On the weekly report, engineers enter their change order numbers....on the monthly report I want a formula that tells me how many change orders they've had from each worksheet. So if the change orders are in C56, C57, C58, C59, C60 on the weekly report, but each week the engineer only had 2 each week. I want there to be a formula that says of the 5 cells from each of the 4 weekly reports, how many were populated with a change order number. Thanks Kimmie40 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculating populated fields from multiple workbooks
If the cells are blank if they do not contain a change order, then you
can just do: =COUNT(week1!C56:C60) or =COUNTA(week1!C56:C60) if they are not proper numbers. You can add these for the four weekly reports to get a composite total, or if the sheets are physically together in the workbook, you could try this: =COUNT(week1:week4!C56:C60) Hope this helps. Pete On Apr 28, 3:01*pm, Kimmie40 wrote: Hi I have weekly reports and then a monthly report every month. *On the weekly report, engineers enter their change order numbers....on the monthly report I want a formula that tells me how many change orders they've had from each worksheet. *So if the change orders are in C56, C57, C58, C59, C60 on the weekly report, but each week the engineer only had 2 each week. *I want there to be a formula that says of the 5 cells from each of the 4 weekly reports, how many were populated with a change order number. Thanks Kimmie40 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculating populated fields from multiple workbooks
On Apr 28, 10:14*am, Pete_UK wrote:
If the cells are blank if they do not contain a change order, then you can just do: =COUNT(week1!C56:C60) or =COUNTA(week1!C56:C60) if they are not proper numbers. You can add these for the four weekly reports to get a composite total, or if the sheets are physically together in the workbook, you could try this: =COUNT(week1:week4!C56:C60) Hope this helps. Pete On Apr 28, 3:01*pm, Kimmie40 wrote: Hi I have weekly reports and then a monthly report every month. *On the weekly report, engineers enter their change order numbers....on the monthly report I want a formula that tells me how many change orders they've had from each worksheet. *So if the change orders are in C56, C57, C58, C59, C60 on the weekly report, but each week the engineer only had 2 each week. *I want there to be a formula that says of the 5 cells from each of the 4 weekly reports, how many were populated with a change order number. Thanks Kimmie40- Hide quoted text - - Show quoted text - Wow....duh...thanks Pete. That was so easy its embarrassing. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculating populated fields from multiple workbooks
Sometimes the easy ones are the most elusive !!
Thanks for feeding back. Pete On Apr 28, 3:31*pm, Kimmie40 wrote: Wow....duh...thanks Pete. * That was so easy its embarrassing |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculating populated fields from multiple workbooks
On Apr 28, 10:41*am, Pete_UK wrote:
Sometimes the easy ones are the most elusive !! Thanks for feeding back. Pete On Apr 28, 3:31*pm, Kimmie40 wrote: Wow....duh...thanks Pete. * That was so easy its embarrassing- Hide quoted text - - Show quoted text - Pete, can you do the same for cells populated with text...not numbers? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculating populated fields from multiple workbooks
Try it using COUNTA rather than COUNT.
Excel is not very good with 3-D stuff, so if: =COUNTA(week1:week4!C56:C60) doesn't work you might have to try it like: =COUNTA(week1!C56:C60) + COUNTA(week2!C56:C60) + COUNTA(week3!C56:C60) + COUNTA(week4!C56:C60) Hope this helps. Pete On Apr 28, 4:56*pm, Kimmie40 wrote: On Apr 28, 10:41*am, Pete_UK wrote: Sometimes the easy ones are the most elusive !! Thanks for feeding back. Pete On Apr 28, 3:31*pm, Kimmie40 wrote: Wow....duh...thanks Pete. * That was so easy its embarrassing- Hide quoted text - - Show quoted text - Pete, can you do the same for cells populated with text...not numbers? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculating values across multiple fields for DSTDEV | Excel Discussion (Misc queries) | |||
Logically Calculating Multiple Fields | Excel Discussion (Misc queries) | |||
matching fields between two workbooks | Excel Worksheet Functions | |||
matching key fields between two workbooks and displaying info when | Excel Worksheet Functions | |||
Calculating fields in pivot tables | Excel Discussion (Misc queries) |