Analyzing Data

  • Thread starter Thread starter bakker
  • Start date Start date
B

bakker

I know at some point in time I did a tutorial or something in which
could analyze date and sum it up. My scenerio is that I am trying t
keep track of my employees payroll based of of pay period and budge
number that there pay comes from. So I have Four columns 1 with th
name of the employee 2 Pay date 3 amount payed 4 Budget number.

So the information I want to get is the toal pay for a particula
budget number for the particular pay date
 
Hi

try
=SUMPRODUCT((B2:B100=F6)*(D2:D100=F7)*(C2:C100))

where F6 contains the Date you're interested in and F7 contains the Budget
Number.
and your data is in A2:D100.

Hope this helps
Cheers
JulieD
 
If you want to look at all dates/all budget numbers, your setup is best
handled by a Pivot Table. See Debra Dalgeish's intro to PT's:

http://peltiertech.com/Excel/Pivots/pivotstart.htm

If you're really after only one budget number for a particular paydate,
and your particular budget number is in F1, and your particular paydate
is in F2:

=SUMPRODUCT(--(B1:B1000=F2),--(D1:D1000=F1),C1:C1000)

See

http://www.mcgimpsey.com/excel/doubleneg.html

for an explanation of the -- in the formula.
 
Back
Top