View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lawrence Lawrence is offline
external usenet poster
 
Posts: 33
Default Using COUNTIF to count based on multiple cell criteria.

OK, I'm no expert, but I had a somewhat similar question, and some guys on
here pointed me in the right direction for me, I made a sample spreadsheet
with your data and utilized the formula they helped me develop and it seems
to work for your problem. Here it is:

=COUNTIFS(A2:A9,"=osh*",B2:B9,"=1/1/2007",B2:B9,"<=1/31/2007")

just change the values for A & B for the total number of entries on your
sheet. Also make sure to change the date to find the different months you
want.
So maybe the experts can help you make this simpler to use.
OH, keep in mind that this formula is for Excel2007.
Hope it helps.
Lawrence

"Disdan" wrote:

Hi, I have the following sample data

I have data identifing (1) the description of a document issued (column
ranged named SI_DES) and (2) the date it was issued (Column range called
ISSUED).

I am able to use the COUNTIF function to count the number of times the term
"OSH" occurs in the description to determine the number of OSH documents are
identified in the total list. - The formula I use is
=COUNTIF(SI_DES,"*OSH*").

I am also able to count the number of if times any given document is issued
per month - The formula I use is
=(COUNTIF(ISSUED,"=3/1/07")-COUNTIF(ISSUED,"3/31/07"))

What I am having troble with is counting the number of OSH documents that
are issued in a given month. I am having troble combing the two formulas
above to generate to answer. If any one can help, it would be much
appreciated.

Thanks