Set up a count and countif?

[pdvinuk]

I've set up a Countif formula for a column that has either High, Medium and
Low
=COUNTIF(D8250,"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

 

[joel]

Use sumproduct to test for two conditions. I'' assume that wehn no data is
issued the cell is blank

=Sumproduct(--(D8250="Low"),--(E8:E250<>""))

Where column E contains the issue dates.

 

[pdvinuk]

Thank you

Worked perfectly

Use sumproduct to test for two conditions. I'' assume that wehn no data is
issued the cell is blank

=Sumproduct(--(D8250="Low"),--(E8:E250<>""))

Where column E contains the issue dates.