Member Avatar for avirooge

Hi,
I have developed a simple result program in excel 2003. I have stuck up at the following point:

I have total seven subjects based on which I need to prepare a result. My aim is to find out failures. My condition is, if a student secures less than 35 marks out of 100 in more than two subjects, then in the Rem column Header "FAIL" should be displayed. Actually I need to find the count which gives me failures in more than 2 subjects. I have used Count(), but it doesn't work?

Plz. Help Me.

Thanking U in advance.

Avinash Rooge

Edited by Ezzaral because: Snipped email. Please keep it on site.
  • 4 Contributors
  • 3 Replies
  • 114 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by AndreRet
Member Avatar for debasisdas

Try using IIF .

Member Avatar for monarchmk

maybe in header cell you can put...
=IF(COUNTIF(B2:B8;"<35")>=2;"FAIL";"PASS")

where B2:B8 is range
"<35" is criteria for Fail...
CountIF(range,crit) gives number of cells in range which meets criteria

Edited by monarchmk because: n/a
Member Avatar for AndreRet

Your count usage is correct. You just need to find the amount of rows affected, devide the count into the rows to get a pass/failure average and then base your condition on the result.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.