Ben Collins(@benlcollins) 's Twitter Profileg
Ben Collins

@benlcollins

Teaching data analysis and automation with Google Sheets at https://t.co/IJQQ3QU6nc
Weekly Google Sheets tips: https://t.co/Ippyz7m843
Google Developer Expert

ID:19338407

linkhttp://benlcollins.com calendar_today22-01-2009 13:43:22

14,5K Tweets

9,7K Followers

1,0K Following

Ben Collins(@benlcollins) 's Twitter Profile Photo
Ben Collins
@benlcollins

1 day ago

Saw this beautiful Barred Owl last week, in trees along the Chesapeake and Ohio Canal National Park

Saw this beautiful Barred Owl last week, in trees along the Chesapeake and Ohio Canal National Park
account_circle
Ben Collins(@benlcollins) 's Twitter Profile Photo
Ben Collins
@benlcollins

6 days ago

Ever seen the /0! error in ?

This error occurs when a number is divided by zero.

Why? Well, you can't divide by 0! ๐Ÿคช

account_circle
Ben Collins(@benlcollins) 's Twitter Profile Photo
Ben Collins
@benlcollins

3 weeks ago

Today I'd like to show you one use case for the SUMPRODUCT function.

Consider this set of student scores.

Each successive test is more important than the last one, with the weightings shown in column C.

Today I'd like to show you one use case for the SUMPRODUCT function. Consider this set of student scores. Each successive test is more important than the last one, with the weightings shown in column C.
account_circle
Ben Collins(@benlcollins) 's Twitter Profile Photo
Ben Collins
@benlcollins

4 weeks ago

Did you know that the ! formula parse error message is unique to ?

It means Google can't understand your formula.

For example, if you concatenate strings but forget the '&' symbol:

='Total'SUM(A1:A10) gives this error, where it should be ='Total'&SUM(A1:A10)

account_circle