Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding digits in a column based on data in a separate column
I am making a log for incoming documents, and need to add the number of days
each type of document takes to be processed. Example: Task Type Days to Complete Type AA 10 Type AA 12 Type BB 6 Type CC 10 Type AA 8 Is there a way to count how many total days all "Type AA" documents took? I've been trying COUNTIF variations and I can't get anything working. THanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding digits in a column based on data in a separate column
Show us what you have tried
-- Don Guillett Microsoft MVP Excel SalesAid Software "adriver" wrote in message ... I am making a log for incoming documents, and need to add the number of days each type of document takes to be processed. Example: Task Type Days to Complete Type AA 10 Type AA 12 Type BB 6 Type CC 10 Type AA 8 Is there a way to count how many total days all "Type AA" documents took? I've been trying COUNTIF variations and I can't get anything working. THanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding digits in a column based on data in a separate column
Assuming your AA = in Column =A, and Num of Days is in Column B.
=SUMPRODUCT(--(A1:A5="AA")*(B1:B5)) "adriver" wrote: I am making a log for incoming documents, and need to add the number of days each type of document takes to be processed. Example: Task Type Days to Complete Type AA 10 Type AA 12 Type BB 6 Type CC 10 Type AA 8 Is there a way to count how many total days all "Type AA" documents took? I've been trying COUNTIF variations and I can't get anything working. THanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding digits in a column based on data in a separate column
Brilliant! I've never seen SUMPRODUCT before, but I dare say my life just
got a lot easier. Thanks! "Mike" wrote: Assuming your AA = in Column =A, and Num of Days is in Column B. =SUMPRODUCT(--(A1:A5="AA")*(B1:B5)) "adriver" wrote: I am making a log for incoming documents, and need to add the number of days each type of document takes to be processed. Example: Task Type Days to Complete Type AA 10 Type AA 12 Type BB 6 Type CC 10 Type AA 8 Is there a way to count how many total days all "Type AA" documents took? I've been trying COUNTIF variations and I can't get anything working. THanks! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding digits in a column based on data in a separate column
SUMPRODUCT() is really great when you need to total things up by multiple
criteria. For example, lets say you had another column that held the initials of the person doing one of the tasks: Task Type Days to Complete Employee Type AA 10 RJ Type AA 12 JB Type BB 6 JB Type CC 10 RJ Type AA 8 RJ you could find out how many days to complete task AA for RJ: =SUMPRODUCT(--($A$1:$A$5="Type AA"),--($C$1:$C$5="RJ"),($B$1:$B$5)) But when only one condition is needed for testing (as in your original request), the solution that RagDyer provided using SUMIF() is more efficient. "adriver" wrote: Brilliant! I've never seen SUMPRODUCT before, but I dare say my life just got a lot easier. Thanks! "Mike" wrote: Assuming your AA = in Column =A, and Num of Days is in Column B. =SUMPRODUCT(--(A1:A5="AA")*(B1:B5)) "adriver" wrote: I am making a log for incoming documents, and need to add the number of days each type of document takes to be processed. Example: Task Type Days to Complete Type AA 10 Type AA 12 Type BB 6 Type CC 10 Type AA 8 Is there a way to count how many total days all "Type AA" documents took? I've been trying COUNTIF variations and I can't get anything working. THanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding column data based on match in 2nd column - Help | Excel Worksheet Functions | |||
Adding data in columns based on criteria in more than one column.. | Excel Worksheet Functions | |||
Adding rows of data based on first column | New Users to Excel | |||
Adding a Custom Column based on an existing Column (EXPERT) | Excel Worksheet Functions | |||
Adding Values Based on a Separate Column | Excel Discussion (Misc queries) |