If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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! |
Thread Tools | |
Display Modes | |
|
|