count the number of fails if the level exists

S

squib

Hi there, I've got a sheet of pass/fails that I'm trying to get th
count of. My problem is that I am classifying them on a scale of 1 t
4. I want to be able to tell how many 1s, 2s, etc. I've got. I ca
get the total count no problem using
=COUNTIF(C15:F181; "F")
Is there any way of just counting the number of Fs in a row that ha
been classified? Any help would be appreciated, thank
 
H

Harlan Grove

squib > said:
Anybody know why this function wouldn't work in openoffice?
Click to expand...

Because OOo Calc is a lightweight spreadsheet. It lacks *most* of Excel's
array semantics and *much* of Excel's array syntax (e.g., there are no array
constants in OOo Calc).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count data in one column indicated by data in another column 5
Excel - count if a number falls within an array in a column & add 2
How do I count the number of items that meet 2 criteria? 5
Combination of IF, AND, and COUNTIF; need help 6
How to count with values from multiple columns? 5
Counting all "F"s in column A where there is also an "A" in column 5
How do I count the number of each number in a column? 6
Counting occurrences of products in a master list 7

Top