View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pdvinuk pdvinuk is offline
external usenet poster
 
Posts: 2
Default Set up a count and countif?

I've set up a Countif formula for a column that has either High, Medium and
Low
=COUNTIF(D8:D250,"Low") etc giving me the data of each.

Corresponding to this column, I have another which will have 'date issued'.
The actual date doesn't matter to me, I just want to set up a formula that
reflects that either the High, Medium or Low has been issued and I want this
number per catagory?

I've tried the 'count' function to no avail?

Can I use count and countif in the same formula?

Many thanks