#1
|
|||
|
|||
Need another formula to match my last one
This is to anyone that can help, but I know that Bird_Fat knows this one but we are unable to stay in contact cause of the time difference. Maybe one of us can work at night. LOL
On sheet #2 is a STAT sheet. I need a total # of word s contining in colm A on sheet #1 that contains the word "ISF" or "REVOKE" or "CONT. SUPV." example: STATUS | TOTAL REVOKE 12 ISF 16 CONT. SUPV. 9 OTHER 5 Thank you |
#2
|
||||
|
||||
I'm still here - LOL!
Hey Tinkertron
I'd say good morning, but it probably isn't - COUNTIF will give you info on criteria counts in a range Code:
=COUNTIF(*range*,"*criteria*") Code:
=COUNTIF(Sheet1!A1:A500,"REVOKE") Is that what you're looking for? |
#3
|
|||
|
|||
Thanks AGAIN! You rock... Why is it that I can not remember these formulas? I geuss you got to do it alot to remember them.
Is there an online study course for just formula? You should see my database spreadsheet. It's turning into a monster! LOL I wouldn't be surpise if this thing became A.I. on me, and put me out of a job. LOL |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help for formula | dehann | Excel | 5 | 05-01-2009 10:44 AM |
Need help with a formula | tinkertron | Excel | 11 | 04-16-2009 11:43 PM |
Excel Formula Help | masoom84 | Excel | 1 | 03-07-2009 09:41 AM |
Excel Formula Help | Shahzad | Excel | 1 | 12-07-2008 04:13 AM |
formula in excell | curlymal | Excel | 2 | 02-09-2007 11:34 AM |