Microsoft Office Forums Need another formula to match my last one
 User Name Remember Me? Password
 Register FAQ Search Today's Posts Mark Forums Read

 Thread Tools Display Modes
#1
04-29-2009, 12:44 PM
 tinkertron Novice Join Date: Mar 2009 Location: Garland, Texas Posts: 15
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
04-29-2009, 02:01 PM
 Bird_FAT Office 2007 Expert Join Date: Apr 2009 Location: South East Posts: 271
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?
#3
04-29-2009, 02:17 PM
 tinkertron Novice Join Date: Mar 2009 Location: Garland, Texas Posts: 15

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 Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post dehann Excel 5 05-01-2009 10:44 AM tinkertron Excel 11 04-16-2009 11:43 PM masoom84 Excel 1 03-07-2009 09:41 AM Shahzad Excel 1 12-07-2008 04:13 AM 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.

 -- Default Style -- Lightweight -- New Mobile Contact Us - Privacy Statement - Top

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