Certificates

Resolved · Medium Priority · Version 2007

Tue 10 Jul 2012, 15:52 Delegate Beverley said...

Beverley has attended:
Taking Minutes course

Certificates

Please assist me with downloading my certificate for the Microsoft Excel Intermediate Training completed.

Please also remind me how to count the number of "yes" in a given range of cells e.g count the number of Yes from C4 to C53.

Thanks

Tue 10 Jul 2012, 17:48 Trainer Anthony said...

RE: Certificates

Hi Beverley, good to hear from you! Your certificate will be posted to you shortly. As for counting the number of yes values try:

=COUNTIF(c4:c53, "Yes")

Hope this helps,

Anthony

Wed 11 Jul 2012, 10:29 Delegate Beverley said...