Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
jbressma
 
Posts: n/a
Default FORMULAS

I cannot figure out if I need to do a COUNT, COUNTIF, or what.....But
basically I am working with a spreadsheet and need to count a total number if
ALL THREE Values hold true. In simpler terms:

COLUMN A=OFFICE
COLUMN B=TITLE
COLUMN C=ACTIVE/INACTIVE

I need to know the total # of people in the Atlanta office (A), who are a
Vice President (B), who are ACTIVE (C).

Hope this is clear.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Please help with Statistics Formulas in Excel Fonz Excel Discussion (Misc queries) 10 April 9th 06 03:22 PM
Formulas not recognizing new data malakingaso Excel Discussion (Misc queries) 1 February 8th 06 07:27 PM
Countif formulas change after doing a sort Bob Smith Excel Worksheet Functions 3 January 3rd 06 11:17 PM
Array Formulas take waaaay too long... belly0fdesire Excel Worksheet Functions 7 August 8th 05 10:11 PM
Problem with named formula's nathan Excel Worksheet Functions 0 January 21st 05 04:07 PM


All times are GMT +1. The time now is 11:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"