#1
|
|||
|
|||
Counting
I have a range of cells that contain the letter "W" and are then followed by a number. I would like to count the cells in that range containing the "W" regardless of what may follow it.
|
#2
|
||||
|
||||
You could use an array formula like:
=SUM(IF(LEFT(A:A,1)="W",1)) Ideally, though, you'd restrict the range to less than an entire row or column (e.g. instead of A:A you might use A1:A100). Array formulae are inserted with Ctrl-Shift-Enter.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
||||
|
||||
Or eventually =SUMPRODUCT(--(LEFT(A1:A100,1)="W"))
which does not need entering with CSE ( if you use Office 2000 entire ranges will not work for sumproduct)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#4
|
|||
|
|||
Or what about a non-array formula or non-array like formula (as SUMPRODUCT)
=COUNTIF(A1:A100,"w*") |
#5
|
|||
|
|||
AWESOME, this works as desired. THANK YOU so much!!!
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Counting unique visitors by ward, counting monthly visits by status, editing existing workbook | JaxV | Excel | 9 | 11-14-2014 12:25 AM |
counting colours | not_dave | Excel | 1 | 12-29-2013 01:27 AM |
various data needs counting | apples | Excel | 2 | 09-16-2012 04:52 AM |
Counting Formula | Karen615 | Excel | 6 | 06-20-2011 07:19 PM |
Counting Colors | g48dd | Excel | 2 | 03-13-2011 09:28 PM |