Software

Ask something
Question Locked

any one giv me sol.

0 helpful
2 replies

by kailash

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

how to put this formula in excel.......
countif(a11,d11,">0<23")

plz plz give me sol. anybody ..

thanks

2 replies

by thumbsup2

.... if you mean to count A11 through D11 (inclusive), you can use this:

=IF(A11:D11 > 0, COUNTIF(A11:D11, "< 23"),"")

If you're looking for EITHER A11 OR D11 being between 0 and 23, there's a different way to go about it.

The help for functions in Excel is very good. Have you tried using it?

This discussion is closed to new replies.