Thread
:
HELP! countif
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
[email protected]
Posts: n/a
HELP! countif
Sounds like an array formula to me
=sum(IF(C6:C600="Peach",IF(E6:E600,"6",1,0)))
enter as ctrl shift enter - NOTE that you need to have an actual range
for this to work (hence my C6:C600 instead of just C or C6)
Reply With Quote