Jump to content
View in the app

A better way to browse. Learn more.

Surly Horns

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Featured Replies

I'm currently adding up flight times in my logbook and need help with a certain formula.  One of my columns denotes what  I was coded as on a certain flight.  The choices are UP, FP, MP, IP, and XP.  How can I find out how many total times I was listed as an IP?  The column in question is "E".  The first cell with data is "E3" and the last is "E1125".  So of those 1122 total entries, how many times was I coded as an IP?

Sum product or countif are the two functions that will do job. 

Sumproduct(--($e$3:$e$1125="IP")*(1))

Just place that in a separate cell and it should work. Doing it from memory so let me know.

I'm currently adding up flight times in my logbook and need help with a certain formula.  One of my columns denotes what  I was coded as on a certain flight.  The choices are UP, FP, MP, IP, and XP.  How can I find out how many total times I was listed as an IP?  The column in question is "E".  The first cell with data is "E3" and the last is "E1125".  So of those 1122 total entries, how many times was I coded as an IP?
A count if formula should do it. In the cell you want that count, =COUNTIF(E3:E1125,"ip")

Unless I’m misunderstanding why don’t you make a pivot table off that data?

1 minute ago, Homercles said:

Unless I’m misunderstanding why don’t you make a pivot table off that data?

This is what I was thinking would be the easiest way to get the count of all the different codes.

Or even easier - just add a filter to the header line, and filter to just the code you want to see and look at total results. 

  • Author
1 minute ago, hornbri said:

Or even easier - just add a filter to the header line, and filter to just the code you want to see and look at total results. 

This is what I ended up doing.

Thanks for the help fellas. 

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.