Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM IF QUESTION PLEASE HELP
I have this spreadsheet and I am trying to include a summing formula where i
have downloaded data from an outside source and i receive my data in the current form: PRAUSR PRFLOC PRBGDT PRBGTI TIME LIFT BELLAMYE A 04 22 03 1 20080502 81535 NO LIFT BELLAMYE A 05 18 05 1 20080502 82457 NO LIFT BELLAMYE A 12 02 02 1 20080502 82505 NO LIFT BELLAMYE A 26 09 02 2 20080502 82523 NO LIFT BERRYA M 01 03 03 2 20080502 81316 LIFT BERRYA M 01 04 04 2 20080502 83032 LIFT BERRYA M 01 07 05 2 20080502 83057 LIFT BERRYA M 02 01 05 1 20080502 83112 LIFT BERRYA A 05 18 03 1 20080502 83811 NO LIFT PRAUSR=Employee PRFLOC=Location My LIFT/NO LIFT formula is as such =IF(OR(E2="A",E2="B",E2="C",E2="D",E2="E",E2="F"), "NO LIFT","LIFT") What I want to do is create a formula that counts only the frequencies an employee reaches a LIFT OR NO LIFT SECTION, so if BERRYE went from "NO LIFT'' to "LIFT" in the next sequence it should equal to one and if theres consecutive "NO LIFT" it should equal to zero |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
where can I see my question and answer? Yesterday I ask a question | Excel Discussion (Misc queries) | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
The question is an excel question that I need to figure out howto do in excel. | Excel Worksheet Functions | |||
Another "IF' question | Excel Discussion (Misc queries) | |||
Another Name question | Excel Discussion (Misc queries) |