Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple conditions
Hello,
I'm working on a attendance and vacation worksheet. The fist tab is a summary of the other 4 tabs. This very similar to Micosofts tracking templete1.I'm having trouble with summing multiple worksheet with a if then statement. Here is what I have so far, =SUM('1st Q:4th Q'!F6). This works fine. I want to also include if the value is greater than 2 "verbal warning, grater than 3 "written waning", greater than 4 "days suspension". I thought about putting the =sum statement in VB, and use the cell for the =if statement, but I'm not to sure how. Thank you for you time! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup with multiple conditions | Excel Worksheet Functions | |||
COUNTIF Multiple Conditions | Excel Discussion (Misc queries) | |||
COUNTIF - multiple conditions | Excel Worksheet Functions | |||
SUM based on multiple conditions - SORRY, URGENT!!! | Excel Worksheet Functions | |||
Summarize data with multiple conditions | Excel Discussion (Misc queries) |