Function to summarize based on 2 conditions?
 

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

Function to summarize based on 2 conditions?
 

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


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=555934

Function to summarize based on 2 conditions?
 

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.

Jess Wrote:
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


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=555934

Function to summarize based on 2 conditions?
 

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.


"starguy" wrote:


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.

Jess Wrote:
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


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=555934

Function to summarize based on 2 conditions?
 

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...

Function to summarize based on 2 conditions?
 

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.

Jess Wrote:
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.
[/color]


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=555934