Function to summarize based on 2 conditions?

J

Jess

Hi...i cant quite figure out how to do this or if there is a way to.
Ive got 3 columns.Employee Name in A,AccCode in B, Total of Hours in C. Each
employee has multiple entries of hours per account code.Account codes are
100,101,102.How do list all the employee's who have put in time for Account
100 only.
The result should look like
Empname AccountCode Hours
ABC 100 20
XYZ 100 56

Thanks in advance
 
D

Dav

As the number and names of your employees are not know in which case I
would use sumproduct, try using data_pivottable report

Regards

Dav
 
S

starguy

select your column headers i-e Empname, AccountCode, Hours, go to Data >
Filter > Auto Filter
now filter your data from the drop down list appearing on your
AccountCode column by selecting 100 (or any other code)

hope this will solve your problem.
 
J

Jess

I could not use the option of auto filter.no options to select my criteria
would come up.i did try advanced filter...but i couldnt...i need a solution
because doing it manually is too time consuming.
 
J

Jess

Hi again, im currently using the sumproduct function,its just too tedious
when dealing with 50 rows.I dont prefer to use pivot tables because im not
familiar to formatting it the way i want.So i still dont have an easier way...
 
S

starguy

i dont know why you have not seen any option to select. it may be
because you may have an empty row between your column headers and data.
delete that row and try autofilter again.
I could not use the option of auto filter.no options to select my
criteria
would come up.i did try advanced filter...but i couldnt...i need a
solution
because doing it manually is too time consuming.
Click to expand...
[/QUOTE]
 
Top