Web Development

Ask something
Discussion Locked

Count in Excel

0 helpful
3 replies

by nik de greek

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

I need a formula to check column c that has ytr in any of it's cells, if they do, then count matches in column e on same sheet, then input answer on another sheet, in same workbook.

A b c d e
GHN4 31/01/01 ytr 2001-11-08 2001-11-14
CROY 29/01/01 2001-10-24
CWH4 31/01/01 ytr 2001-11-08
WAN4 29/01/01 ytr 2001-11-16

The answer here would be one (1).

3 replies

by dklippert

I assume you meant did NOT have ytr as an entry in order to get the count of 1.
If so, try this array formula:

{=SUM((Sheet1!C2:C5<>"ytr")*(Sheet1!E2:E5<>""))}

(Array?s are entered using Ctrl+Shift+Enter. You can not enter the braces from thekeyboard.)

For more information on counting, try:

http://j-walk.com/ss/excel/tips/tip52.htm

(There are no spaces in the URL)

This discussion is closed to new replies.