Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-05-2006, 07:59 AM
AdamNT AdamNT is offline
Novice
How to count cells containing data and meet certain criteria
 
Join Date: Jun 2006
Posts: 1
AdamNT
Default How to count cells containing data and meet certain criteria

Can anyone help,

I want to count the number of cells in 2 columns that match 2 sets of criteria.

Basically I have a list of activities with dates next to them, like a record of work. I have on a separate page a table to summarise all the activities in rows and the months in columns.

In separate columns I have managed to:
- convert the full date to a numeric value ie; Jan = 1, Feb =2
- convert the "activity" to numeric value 1-20



I just need a formula to look down each column and count for each month how many times each activity occurs

Is this possible?

Please help....... :-)
Reply With Quote
  #2  
Old 08-11-2006, 11:51 PM
SerenityNetworks SerenityNetworks is offline How to count cells containing data and meet certain criteria Windows 10 How to count cells containing data and meet certain criteria Office 2016
Advanced Beginner
 
Join Date: May 2005
Location: Allen, Texas, USA
Posts: 37
SerenityNetworks
Default

Yes, it is possible. You need to use an "array" formula. You will find it very handy. It takes a little getting used to, but once you've got it then you will find you use it all the time.

Where the functions countif and sumif will only work on one set of criteria, an array formula will let you work with multiple criteria - as many as you need. Cool!

The following link has the best explanation that I've seen. http://www.cpearson.com/excel/array.htm

Regards,
Andrew


[/url]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to count cells containing data and meet certain criteria How to get cells to calculate time? jrasche2003@yahoo.com Excel 2 02-09-2007 07:10 AM
Don't count 0 in a chart Rmaisone Excel 0 08-21-2006 12:26 PM
Automatically entering/fill data in cells in Excel 2003 dipdog Excel 0 08-17-2006 08:37 AM
How to count cells containing data and meet certain criteria Multiple criteria in SUMIF? pumpkin head Excel 1 02-17-2006 09:06 AM
How to count cells containing data and meet certain criteria Filtering past or future events in DRW query criteria jvieille Misc 1 02-11-2006 06:26 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:30 PM.


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