Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dynamic formulas
I am currently trying to get a cell to recognize the amount of work completed
by employees on a certain day, automatically. Each employee uses a monthly log, and column A includes the day in M/DD format, whereas column G includes the word "Completed" or "Deferred." I have worked out the formula to get a different tab to count up "Completed" in a range of column G, but as the sheet is monthly I am unable to get it to count up the amount for a specific day, so they may manage their productivity. How would I be able to get Excel to recognize today's date, and count up the amount completed in column G just for that date? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dynamic formulas
Try this:
=SUMPRODUCT(--(A1:A10=TODAY()),--(G1:G10="completed")) -- Biff Microsoft Excel MVP "Damien" wrote in message ... I am currently trying to get a cell to recognize the amount of work completed by employees on a certain day, automatically. Each employee uses a monthly log, and column A includes the day in M/DD format, whereas column G includes the word "Completed" or "Deferred." I have worked out the formula to get a different tab to count up "Completed" in a range of column G, but as the sheet is monthly I am unable to get it to count up the amount for a specific day, so they may manage their productivity. How would I be able to get Excel to recognize today's date, and count up the amount completed in column G just for that date? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dynamic formulas
That worked perfectly, once I modified the ranges for my sheet. Thank you!
How might I cause it to count all non-empty cells for that same range, instead of completed? I'm using =SUMPRODUCT(--(B1:B1000=TODAY()),--(G1:G1000="Completed")) to track completed, and =SUMPRODUCT(--(B1:B1000=TODAY())) for all listed under that range, but I'd like to make it count up the range in the G range rather than B range. Thanks again! "T. Valko" wrote: Try this: =SUMPRODUCT(--(A1:A10=TODAY()),--(G1:G10="completed")) -- Biff Microsoft Excel MVP "Damien" wrote in message ... I am currently trying to get a cell to recognize the amount of work completed by employees on a certain day, automatically. Each employee uses a monthly log, and column A includes the day in M/DD format, whereas column G includes the word "Completed" or "Deferred." I have worked out the formula to get a different tab to count up "Completed" in a range of column G, but as the sheet is monthly I am unable to get it to count up the amount for a specific day, so they may manage their productivity. How would I be able to get Excel to recognize today's date, and count up the amount completed in column G just for that date? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dynamic formulas
Try this:
=SUMPRODUCT(--(B1:B1000=TODAY()),--(G1:G1000<"completed"),--(G1:G1000<"")) -- Biff Microsoft Excel MVP "Damien" wrote in message ... That worked perfectly, once I modified the ranges for my sheet. Thank you! How might I cause it to count all non-empty cells for that same range, instead of completed? I'm using =SUMPRODUCT(--(B1:B1000=TODAY()),--(G1:G1000="Completed")) to track completed, and =SUMPRODUCT(--(B1:B1000=TODAY())) for all listed under that range, but I'd like to make it count up the range in the G range rather than B range. Thanks again! "T. Valko" wrote: Try this: =SUMPRODUCT(--(A1:A10=TODAY()),--(G1:G10="completed")) -- Biff Microsoft Excel MVP "Damien" wrote in message ... I am currently trying to get a cell to recognize the amount of work completed by employees on a certain day, automatically. Each employee uses a monthly log, and column A includes the day in M/DD format, whereas column G includes the word "Completed" or "Deferred." I have worked out the formula to get a different tab to count up "Completed" in a range of column G, but as the sheet is monthly I am unable to get it to count up the amount for a specific day, so they may manage their productivity. How would I be able to get Excel to recognize today's date, and count up the amount completed in column G just for that date? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Formulas | Excel Worksheet Functions | |||
How to Evaluate Dynamic DDE Formulas | Excel Worksheet Functions | |||
Dynamic formulas including worksheet references | Excel Worksheet Functions | |||
dynamic formulas | Excel Discussion (Misc queries) | |||
Dynamic Formulas with Dynamic Ranges | Excel Worksheet Functions |