The problem is thus:
I am trying to count the volume of cells on a sheet with the value
"total", but I don't know how to!

Does anyone in googleland have any ideas?

Thanks for your help,

Peter

Have a look in the help index for COUNTIF
--
Don Guillett
SalesAid Software
(E-Mail Removed)
"Peter" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> The problem is thus:
> I am trying to count the volume of cells on a sheet with the value
> "total", but I don't know how to!
>
> Does anyone in googleland have any ideas?
>
> Thanks for your help,
>
> Peter
>

=countif(a1:a100,"total")
or
=countif(a1:a100,"*total*")

Adjust your range to match what you need.

Peter wrote:
>
> The problem is thus:
> I am trying to count the volume of cells on a sheet with the value
> "total", but I don't know how to!
>
> Does anyone in googleland have any ideas?
>
> Thanks for your help,
>
> Peter

--

Dave Peterson

Thanks for the reply but countif does not seem to work in VBA. Sorry
for not being clear in my question but I am writing a macro in VBA. If
you can do it in Excel I'm sure you can do it in VBA.

Thanks,

Peter

application.countif(range("
--
Don Guillett
SalesAid Software
(E-Mail Removed)
"Peter" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Thanks for the reply but countif does not seem to work in VBA. Sorry
> for not being clear in my question but I am writing a macro in VBA. If
> you can do it in Excel I'm sure you can do it in VBA.
>
> Thanks,
>
> Peter
>

or
for each c in range("a2:a22")
if ucase(c)="TOTAL" then mc=mc+1
next
msgbox mc

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"Peter" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Thanks for the reply but countif does not seem to work in VBA. Sorry
> for not being clear in my question but I am writing a macro in VBA. If
> you can do it in Excel I'm sure you can do it in VBA.
>
> Thanks,
>
> Peter
>

Thanks,

This is what I did in the end:

Cells(1, 4) = "=COUNTIF(R[0]C[-1]:R[" & c & "]C[-1],""Total"")"
m = Cells(1, 4).Value
Cells(1, 4).Select
Selection.Clear
MsgBox m & " totals"


Peter



Don Guillett wrote:
> or
> for each c in range("a2:a22")
> if ucase(c)="TOTAL" then mc=mc+1
> next
> msgbox mc
>
> --
> Don Guillett
> SalesAid Software
> (E-Mail Removed)
> "Peter" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Thanks for the reply but countif does not seem to work in VBA. Sorry
> > for not being clear in my question but I am writing a macro in VBA. If
> > you can do it in Excel I'm sure you can do it in VBA.
> >
> > Thanks,
> >
> > Peter
> >

If you like it?

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"Peter" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Thanks,
>
> This is what I did in the end:
>
> Cells(1, 4) = "=COUNTIF(R[0]C[-1]:R[" & c & "]C[-1],""Total"")"
> m = Cells(1, 4).Value
> Cells(1, 4).Select
> Selection.Clear
> MsgBox m & " totals"
>
>
> Peter
>
>
>
> Don Guillett wrote:
>> or
>> for each c in range("a2:a22")
>> if ucase(c)="TOTAL" then mc=mc+1
>> next
>> msgbox mc
>>
>> --
>> Don Guillett
>> SalesAid Software
>> (E-Mail Removed)
>> "Peter" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> > Thanks for the reply but countif does not seem to work in VBA. Sorry
>> > for not being clear in my question but I am writing a macro in VBA. If
>> > you can do it in Excel I'm sure you can do it in VBA.
>> >
>> > Thanks,
>> >
>> > Peter
>> >
>

To be honest I prefered your way, it was just while I was waiting I
worked out the above.

Thanks for the help,

Peter

On Dec 27, 5:34 pm, "Don Guillett" <dguille...@austin.rr.com> wrote:
> If you like it?
>
> --
> Don Guillett
> SalesAid Software
> dguille...@austin.rr.com"Peter" <peter.a.r...@googlemail.com> wrote in messagenews:(E-Mail Removed)...
>
>
>
> > Thanks,
>
> > This is what I did in the end:
>
> > Cells(1, 4) = "=COUNTIF(R[0]C[-1]:R[" & c & "]C[-1],""Total"")"
> > m = Cells(1, 4).Value
> > Cells(1, 4).Select
> > Selection.Clear
> > MsgBox m & " totals"
>
> > Peter
>
> > Don Guillett wrote:
> >> or
> >> for each c in range("a2:a22")
> >> if ucase(c)="TOTAL" then mc=mc+1
> >> next
> >> msgbox mc
>
> >> --
> >> Don Guillett
> >> SalesAid Software
> >> dguille...@austin.rr.com
> >> "Peter" <peter.a.r...@googlemail.com> wrote in message
> >>news:(E-Mail Removed)...
> >> > Thanks for the reply but countif does not seem to work in VBA. Sorry
> >> > for not being clear in my question but I am writing a macro in VBA. If
> >> > you can do it in Excel I'm sure you can do it in VBA.
>
> >> > Thanks,
>
> >> > Peter- Hide quoted text -- Show quoted text -