Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF,And,OR Help
I need help adding another condition to my formula.I need AE9 to = "Epress" or ="EXPU". At this time it only returns a response for ="Express" =IF(AND(J9="yes",AK9="yes",AE9="Express"),1,"") I also need this formula to total the column. AE9:AE200. -- lostinformulas ------------------------------------------------------------------------ lostinformulas's Profile: http://www.excelforum.com/member.php...o&userid=35229 View this thread: http://www.excelforum.com/showthread...hreadid=550065 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF,And,OR Help
try
=IF(AND(J9="yes",AK9="yes",or(AE9="Express",AE9="E press",AE9="EXPU")),sum(AE9:AE200),"") Are you sure on summiing the AE9 since you are looking for text in AE9? "lostinformulas" wrote: I need help adding another condition to my formula.I need AE9 to = "Epress" or ="EXPU". At this time it only returns a response for ="Express" =IF(AND(J9="yes",AK9="yes",AE9="Express"),1,"") I also need this formula to total the column. AE9:AE200. -- lostinformulas ------------------------------------------------------------------------ lostinformulas's Profile: http://www.excelforum.com/member.php...o&userid=35229 View this thread: http://www.excelforum.com/showthread...hreadid=550065 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF,And,OR Help
=IF(AND(J9="yes",AK9="yes",OR(AE9="Express",AE9="E XPU")),SUM(AE9:AE200),"") Note your SUM will "include" the word EXPRESS or EXPU ... will still work. HTH "lostinformulas" wrote: I need help adding another condition to my formula.I need AE9 to = "Epress" or ="EXPU". At this time it only returns a response for ="Express" =IF(AND(J9="yes",AK9="yes",AE9="Express"),1,"") I also need this formula to total the column. AE9:AE200. -- lostinformulas ------------------------------------------------------------------------ lostinformulas's Profile: http://www.excelforum.com/member.php...o&userid=35229 View this thread: http://www.excelforum.com/showthread...hreadid=550065 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF,And,OR Help
=IF(AND(J9="yes",AK9="yes",(OR(AE9="express", AE9="epress", AE9="EXPU"))),SUM(AE9:AE200),"") -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=550065 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF,And,OR Help
I guess I don't need a sum but need to count the times that either Express or EXPU appears between AE9:AE200 -- lostinformulas ------------------------------------------------------------------------ lostinformulas's Profile: http://www.excelforum.com/member.php...o&userid=35229 View this thread: http://www.excelforum.com/showthread...hreadid=550065 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF,And,OR Help
=countif(AE9:AE200,"=Express")+countif(AE9:AE200," =EXPU")
"lostinformulas" wrote: I guess I don't need a sum but need to count the times that either Express or EXPU appears between AE9:AE200 -- lostinformulas ------------------------------------------------------------------------ lostinformulas's Profile: http://www.excelforum.com/member.php...o&userid=35229 View this thread: http://www.excelforum.com/showthread...hreadid=550065 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF,And,OR Help
Were getting closer. =IF(AND(J9="yes",AK9="yes",(OR(AE9="express", AE9="epress", AE9="EXPU"))),COUNTIF(AE9:AE200, "express")+COUNTIF(AE9:AE200, "epress")+COUNTIF(AE9:AE200, "EXPU"),"") This counts all the Express and EXPU between AE9:AE200. I need it to only count these if the cooresponding J and AK = yes J9=yes AK9=yes AE9=express J10=no AK10=yes AE10=EXPU J11=yes AK10=yes AE11= blank cell j12 =yes AK12=yes AE12=EXPU Row 9 would = 1 Row 10 would = 0 Row 11 would = 0 Row 12 would = 1 Total count = 2 Thank you everyone for your help -- lostinformulas ------------------------------------------------------------------------ lostinformulas's Profile: http://www.excelforum.com/member.php...o&userid=35229 View this thread: http://www.excelforum.com/showthread...hreadid=550065 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF,And,OR Help
=IF(AND(J9="yes",AK9="yes",(OR(AE9="express", AE9="epress", AE9="EXPU"))),1,0) And whereever you have total count, just do a =SUM() -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=550065 |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF,And,OR Help
The following will count the number of cells that has "express" "epress" and "EXPU" if AE9 = express, epress or EXPU: =IF(AND(J9="yes",AK9="yes",(OR(AE9="express", AE9="epress", AE9="EXPU"))),Countif(AE9:AE200, "express")+Countif(AE9:AE200, "epress")+Countif(AE9:AE200, "EXPU"),"") The following will count the number of cells that has whatever is in AE9, so if AE9 has express, it will count how many times express shows up, if AE9 has epress, it will count how many times epress shows up.. and so forth: =IF(AND(J9="yes",AK9="yes",(OR(AE9="express", AE9="epress", AE9="EXPU"))),Countif(AE9:AE200, AE9),"") -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=550065 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|