Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trying to build a If statement
I am an employer and my employees give me a sheet of the hours that they
worked and the name of the client they were at. Can I build a sheet to include the hours worked, the client and then have it add up the indiviual clients hours. in one cell with a if statement ex =if(a2=gallery,sum b3-b2,"") Galley clients name |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trying to build a If statement
Make a database
a b c employee client hours then just use a sumproduct for each employee & client using dropdown lists -- Don Guillett Microsoft MVP Excel SalesAid Software "dlbooks" wrote in message ... I am an employer and my employees give me a sheet of the hours that they worked and the name of the client they were at. Can I build a sheet to include the hours worked, the client and then have it add up the indiviual clients hours. in one cell with a if statement ex =if(a2=gallery,sum b3-b2,"") Galley clients name |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trying to build a If statement
I built a worksheet one for each employee. with a drop down of the clients
so after i put in their hours i will choose which client it belongs to. Now how do format a cell to add up all the same client names to show how long they were there? "Don Guillett" wrote: Make a database a b c employee client hours then just use a sumproduct for each employee & client using dropdown lists -- Don Guillett Microsoft MVP Excel SalesAid Software "dlbooks" wrote in message ... I am an employer and my employees give me a sheet of the hours that they worked and the name of the client they were at. Can I build a sheet to include the hours worked, the client and then have it add up the indiviual clients hours. in one cell with a if statement ex =if(a2=gallery,sum b3-b2,"") Galley clients name |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Build too for ordering | New Users to Excel | |||
How to build effective IF Statement for recurring value in cells....sensitivity analysis | Excel Discussion (Misc queries) | |||
Build Formula | Excel Worksheet Functions | |||
How do I build this Macro? | Excel Discussion (Misc queries) | |||
How would I build an "if" formula... | Excel Worksheet Functions |