Check out some problems solved by our top Experts or click here to post your own problem for free!

I need to count the number of data/rows in a sheet

Solved by O. U. in 37 mins

I am looking to create a formula that will count the number of unique values with particular parameters. For example:
Lays Original Process A204
Lays Original Packaged A204
Lays Original Process A206
Lays BBQ Process A403
Lays Original Packaged A206
I would like to count how many Lays Original Packaged Code. The result from this list should be 2 (A204 and A206).

Solved by Z. W. in 20 mins

I need to calculate the number of female board members and directors for each company, also the % of females and how they compare to number and % of men in the same firms. Only small firms should count and only board members and relevant associating functions.

Solved by K. D. in 41 mins

i need to adjust a formula to not count blank cells

Solved by Z. J. in 60 mins

I need to be able to count certain letters as numbers and then add them all up
=((COUNTIF(P19:P28,"A")*12),(COUNTIF(P19:P28,"B")*12),(COUNTIF(P19:P28,"C")*8),(COUNTIF(P19:P28,"D")*8),(COUNTIF(P19:P28,"E")*12),(COUNTIF(P19:P28,"F")*8),(COUNTIF(P19:P28,"G")*12),(COUNTIF(P19:P28,"H")*8),(COUNTIF(P19:P28,"I")*12)) this is what I was trying to use

Solved by V. F. in 31 mins

I have a formula that counts non blank cells in Cell A2 now i want to create another array formula where in i want to use this count as one of the reference i.e. $F$1:$F$(value in cell A2). Please advice?

Solved by B. C. in 45 mins

so there is a list of names, an amount of time next to each name and a date this name and time were entered. so i have a formula that counts the times a unique name appears in the list, i want it to count between whatever dates i specify

Solved by T. H. in 60 mins

in he cell K24 count the number of values in the range B6:K12 greater than 200

Solved by G. E. in 20 mins