count multiple arguments with a criteria....

[Moogambikai]

Hi all,

I would require this formula if any body cud help me out in this?

To count the cells with specific criteria across the sheet exceeding 30..

answer required ASAP.

 

[Gerald Higgins]

Hi, welcome to the board.

Can you clarify what you mean please ?

 

[kidwispa]

Hi all,

I would require this formula if any body cud help me out in this?

To count the cells with specific criteria across the sheet exceeding 30..

answer required ASAP.

If I'm right in thinking you want to count every cell where the value is greater than 30 then use this formula (change the word "range" to the actual range you want to look at)...

=countif(range,">30")