Sumif() help

Sumif() help

Post by jhorsle » Sat, 29 Oct 2005 02:19:17



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/
 
 
 

Sumif() help

Post by Paul Shepp » Sat, 29 Oct 2005 02:29:46


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/