Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-29-2009, 12:44 PM
tinkertron tinkertron is offline
Novice
Need another formula to match my last one
 
Join Date: Mar 2009
Location: Garland, Texas
Posts: 15
tinkertron is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 04-29-2009, 02:01 PM
Bird_FAT's Avatar
Bird_FAT Bird_FAT is offline Need another formula to match my last one Need another formula to match my last one Office 2007
Expert
 
Join Date: Apr 2009
Location: South East
Posts: 271
Bird_FAT is on a distinguished road
Default 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*")
ie - to find the number of times the word REVOKE is written in Sheet1, Cell range A1:A500:

Code:
=COUNTIF(Sheet1!A1:A500,"REVOKE")
All you need to do is copy the formula and paste it for each of your totals columns and change the criteria!

Is that what you're looking for?
Reply With Quote
  #3  
Old 04-29-2009, 02:17 PM
tinkertron tinkertron is offline
Novice
Need another formula to match my last one
 
Join Date: Mar 2009
Location: Garland, Texas
Posts: 15
tinkertron is on a distinguished road
Default

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
Reply With Quote
Reply

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 another formula to match my last one 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
Need another formula to match my last one Excel Formula Help Shahzad Excel 1 12-07-2008 04:13 AM
formula in excell curlymal Excel 2 02-09-2007 11:34 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 10:32 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft