Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Another question about IF(COUNTIF) checks in Excel
wrote in message ... Hey again, Is there a formula I can use to figure out if there is one specific phrase in a selection? I'm updating the attendance prgram at the school that I work at. Every student has their own attendance sheet in Excel, and each sheet sort of looks like this: |Monday| Period 1:| A | (A=Absent; S=Seat time) Period 2:| S | Period 3:| A | So basically, if they have one or more "S"s, we can count them as being present for the day. I need the formula to find out if there is an "S" in that column, and if there is, I need it to type an "S" in the attendance report, which sort of looks like this: DATE: |1|2|3| Student Name |S| | | Sorry if that got a little complicated. Is there any way to do this? Oh, one more question. This is rediculously complicated, I know, but... when you use the IF(COUNTIF) formula, can you put another IF(COUNTIF) check in the "value if false" spot? Because if there isn't an "S" in the column, it needs to be able to check for a "P" or an "N" (independent study or not enrolled) and mark that instead. I've been trying to figure it out with the =OR formula but I keep getting errors. This is what I've been typing that's not working and I don't know why: =OR(IF(COUNTIF(AA8:AA10,"S"),"S",(IF(COUNTIF(AA8:A A10,"P"),"P","A")))) Any ideas? |
#2
|
|||
|
|||
Maybe...
=IF(COUNTIF(AA8:AA10,"S"),"S",IF(COUNTIF(AA8:AA10, "P"),"P","A")) would do what you want. Tiff1618 wrote: wrote in message ... Hey again, Is there a formula I can use to figure out if there is one specific phrase in a selection? I'm updating the attendance prgram at the school that I work at. Every student has their own attendance sheet in Excel, and each sheet sort of looks like this: |Monday| Period 1:| A | (A=Absent; S=Seat time) Period 2:| S | Period 3:| A | So basically, if they have one or more "S"s, we can count them as being present for the day. I need the formula to find out if there is an "S" in that column, and if there is, I need it to type an "S" in the attendance report, which sort of looks like this: DATE: |1|2|3| Student Name |S| | | Sorry if that got a little complicated. Is there any way to do this? Oh, one more question. This is rediculously complicated, I know, but... when you use the IF(COUNTIF) formula, can you put another IF(COUNTIF) check in the "value if false" spot? Because if there isn't an "S" in the column, it needs to be able to check for a "P" or an "N" (independent study or not enrolled) and mark that instead. I've been trying to figure it out with the =OR formula but I keep getting errors. This is what I've been typing that's not working and I don't know why: =OR(IF(COUNTIF(AA8:AA10,"S"),"S",(IF(COUNTIF(AA8:A A10,"P"),"P","A")))) Any ideas? -- Dave Peterson |
#3
|
|||
|
|||
Perfect. Thank you so much!
"Dave Peterson" wrote: Maybe... =IF(COUNTIF(AA8:AA10,"S"),"S",IF(COUNTIF(AA8:AA10, "P"),"P","A")) would do what you want. Tiff1618 wrote: wrote in message ... Hey again, Is there a formula I can use to figure out if there is one specific phrase in a selection? I'm updating the attendance prgram at the school that I work at. Every student has their own attendance sheet in Excel, and each sheet sort of looks like this: |Monday| Period 1:| A | (A=Absent; S=Seat time) Period 2:| S | Period 3:| A | So basically, if they have one or more "S"s, we can count them as being present for the day. I need the formula to find out if there is an "S" in that column, and if there is, I need it to type an "S" in the attendance report, which sort of looks like this: DATE: |1|2|3| Student Name |S| | | Sorry if that got a little complicated. Is there any way to do this? Oh, one more question. This is rediculously complicated, I know, but... when you use the IF(COUNTIF) formula, can you put another IF(COUNTIF) check in the "value if false" spot? Because if there isn't an "S" in the column, it needs to be able to check for a "P" or an "N" (independent study or not enrolled) and mark that instead. I've been trying to figure it out with the =OR formula but I keep getting errors. This is what I've been typing that's not working and I don't know why: =OR(IF(COUNTIF(AA8:AA10,"S"),"S",(IF(COUNTIF(AA8:A A10,"P"),"P","A")))) Any ideas? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Question....Help !!!! | Excel Discussion (Misc queries) | |||
eXceL 2003 - list or combo box question | Excel Discussion (Misc queries) | |||
Question about XML functionality (add-ons?) in Excel 2000 & 2002 | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
How do I spell numbers as words for writing checks in Excel? | Excel Worksheet Functions |