Hey all,

I've got a list of cost codes the amount charged and the person who

charged them. The cost code can change. I'm wanting to sum the amount

that each person charged for each cost code.

I've attached a sample file. I was trying to use a sumif but that has

me looking at two variables in a single variable function.

Thanks for the help.

+-------------------------------------------------------------------+

|Filename: Book 3.zip |

|Download: http://www.yqcomputer.com/ |

+-------------------------------------------------------------------+

--

jhorsley

------------------------------------------------------------------------

jhorsley's Profile: http://www.yqcomputer.com/

View this thread: http://www.yqcomputer.com/

jhorsley Wrote:

Hi again jhorsley

Looking at your data in book 3, the best way to get the result you wan

would be with a pivot table, but to do this you would need to ad

headers to each column, column A = Code, B = Cost & C = Person

or

=SUM(IF($A$2:$A$26=43218,IF($C$2:$C$26="Don

Donaldson",$B$2:$B$26,0),0)) enterred as an array (CTRL/SHIFT/ENTER

-----------------------------------------------------------------------

Paul Sheppard's Profile: http://www.yqcomputer.com/

View this thread: http://www.yqcomputer.com/

3. SumIf Help??

5. Sumif() help

8. SUMIF help!

10. IF or SUMIF help for Overtime Formula

11. SUMIF HELP!!!

12. SumIf Help

14. SUMIF HELP

2 post • Page:**1** of **1**