Counting from a range

[vijsachin]

Hi All,

Basically want to count the number values from a range in specifed grid.

Attached is a file with the formulas that can help you better in knowing the exact requirement is. Please have a look.

Regards,
Vij

[NBVC]

see attached...

[LauraGB]

Hi

Use something similar to :

=COUNTIF(A:A,">=41")-COUNTIF(A:A,">=61")

Laura GB

[Andrew-Mark]

Did you mean to miss out all the scores between 90 and 100?

[vijsachin]

No Andrew, that seems to be a typo in the grid I made. Will correct that . Thanks a bunch for the help

Cheers!
Sachin

[vijsachin]

Another related to the same, use pivot table i made the report for three months. Every month the number of employee strength changes also then and if I want to see whether how many folks actually reached the benchmark with sub depts.

The attachment can help, Choose different months and then you can the formula is also taken the count of the total, which it should not. Can you have a dynamic range set for this?

Cheers!
Vij

Book1-3.xls

[NBVC]

You can replace the B1500 in your formulae with INDEX(B:B,MATCH("Grand Total",A:A,0)-1)

e.g. for B2 formula would be:

Please Login or Register  to view this content.

This will make the formula dynamic and it will count up to the cell before the one in the row containing "Grand Total" in column A

[vijsachin]

Hail the almighty NVBC.... Sorry, but can i know your real name. You are simply a genius

Cheers!
Vij