Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 



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 12:52 AM.


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