| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count matched cells
I have a tracker with 1 of the columns being the requested due date & one is
the actual completed date. I need a formula that will compare these 2 cells in the row & calculate how many times the due date was met. So in cell A1 I have a running total of how many projects met the due date. Is there a countif formula for this? Thank you! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count matched cells
Assming there are no empty cells...
Try something like this: =SUMPRODUCT(--(A1:A10=B1:B10)) -- Biff Microsoft Excel MVP "KB" wrote in message ... I have a tracker with 1 of the columns being the requested due date & one is the actual completed date. I need a formula that will compare these 2 cells in the row & calculate how many times the due date was met. So in cell A1 I have a running total of how many projects met the due date. Is there a countif formula for this? Thank you! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count matched cells
Perfect! Thanks so much!
"T. Valko" wrote: Assming there are no empty cells... Try something like this: =SUMPRODUCT(--(A1:A10=B1:B10)) -- Biff Microsoft Excel MVP "KB" wrote in message ... I have a tracker with 1 of the columns being the requested due date & one is the actual completed date. I need a formula that will compare these 2 cells in the row & calculate how many times the due date was met. So in cell A1 I have a running total of how many projects met the due date. Is there a countif formula for this? Thank you! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count matched cells
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "KB" wrote in message ... Perfect! Thanks so much! "T. Valko" wrote: Assming there are no empty cells... Try something like this: =SUMPRODUCT(--(A1:A10=B1:B10)) -- Biff Microsoft Excel MVP "KB" wrote in message ... I have a tracker with 1 of the columns being the requested due date & one is the actual completed date. I need a formula that will compare these 2 cells in the row & calculate how many times the due date was met. So in cell A1 I have a running total of how many projects met the due date. Is there a countif formula for this? Thank you! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting Matched Values | Excel Worksheet Functions | |||
| How to count the matched values? | Excel Discussion (Misc queries) | |||
| How to count the matched values? | Excel Worksheet Functions | |||
| Multiple Matched Lines | Excel Discussion (Misc queries) | |||
| SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
Linear Mode
