Simple Sumif formual with Criteria
=COUNT(IF((A1:A9="Muziq")*(B1:B9=""),(A1:A9="Muzi q")*(B1:B9="")*1))
*Entered as an array formula with Ctrl+Shift+Enter
Try it like this:
=COUNT(IF((A1:A9="Muziq")*(B1:B9=""),1))
=COUNT(1/((A1:A9="Muziq")*(B1:B9="")))
--
Biff
Microsoft Excel MVP
"GTVT06" wrote in message
...
On Feb 20, 9:54 pm, yshridhar
wrote:
If the data is inthe range a1:a10
=countif(a1:a10,a1)
with regards
Sreedhar
He could however, use a COUNT(IF similar to my SUM(IF suggestion by
entering:
=COUNT(IF((A1:A9="Muziq")*(B1:B9=""),(A1:A9="Muziq ")*(B1:B9="")*1))
*Entered as an array formula with Ctrl+Shift+Enter
As with pretty much anything in Excel, There are several ways to get
the results he's looking for
|