I need to get a total of all values in column C only if column A equals Department and Column B equal TeamA.
A________________B_______________C
Department______TeamA___________.25
Department______TeamA__________1.0
Division________TeamA__________2.0
Department______TeamB__________3.0
Department______TeamA___________.25
I only want the total to include rows 1,2 and 5. The value would be 1.5
I tried the SUMIF command, but that only includes one column of criteria. (That I know how to do).
Is there an easy way to do this with a formula?
Thanks.
This message was edited by sholmb1 on 2002-04-09 21:17
This message was edited by sholmb1 on 2002-04-09 21:17
This message was edited by sholmb1 on 2002-04-09 21:20
A________________B_______________C
Department______TeamA___________.25
Department______TeamA__________1.0
Division________TeamA__________2.0
Department______TeamB__________3.0
Department______TeamA___________.25
I only want the total to include rows 1,2 and 5. The value would be 1.5
I tried the SUMIF command, but that only includes one column of criteria. (That I know how to do).
Is there an easy way to do this with a formula?
Thanks.
This message was edited by sholmb1 on 2002-04-09 21:17
This message was edited by sholmb1 on 2002-04-09 21:17
This message was edited by sholmb1 on 2002-04-09 21:20