Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting, multiple conditions and results
Hi,
I'm working with payperiods, 1-26. Each payperiod will have either a payment amount due or is marked na. If payperiod 5 is the beginning of the amounts due then the previous ones will be marked na. Each payperiod column has formula to figure out if there should be an amount due or an na. What I need is for the amounts due to have a total of 6 payperiods and the remaining payperiods to override the columns existing formula and say "end of 12 weeks". Amounts due would be consecutive. I can have only amounts due for 6 payperiods in total. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting, multiple conditions and results
I think I did a poor job of explaining. I'll try again and repost. "Kathleen" wrote: Hi, I'm working with payperiods, 1-26. Each payperiod will have either a payment amount due or is marked na. If payperiod 5 is the beginning of the amounts due then the previous ones will be marked na. Each payperiod column has formula to figure out if there should be an amount due or an na. What I need is for the amounts due to have a total of 6 payperiods and the remaining payperiods to override the columns existing formula and say "end of 12 weeks". Amounts due would be consecutive. I can have only amounts due for 6 payperiods in total. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting for multiple conditions | Excel Worksheet Functions | |||
Help with counting multiple conditions | Excel Discussion (Misc queries) | |||
Need Formulas for counting multiple conditions | Excel Worksheet Functions | |||
Counting Unique Records with multiple conditions | Excel Worksheet Functions | |||
Counting occurrences of multiple conditions | Excel Discussion (Misc queries) |