Help With A Formula That Sums Items In A Column
Thanks, Dave. Much appreciated.
I was trying to do it with "Sumif".
Still balmy in NY?
Gatsbt (Not The Great)
"Dave F" wrote:
=COUNTIF(W9:W60,"AO")
Dave
--
Brevity is the soul of wit.
"Gatsby" wrote:
Column W9 to W60 has different reference codes in different rows.
For example: W9 AO, W10 AX, W11 A1.......W60 AO.
How do I sum the number of say, AO's in Column W9 to W60 inclusive?
It's a formula I need.
Thanks in advance,
Gatsby (Not The Great)
|