Jump to content

Excel Formula Help


Recommended Posts

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?

Link to comment
Share on other sites

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")
  • Like 2
Link to comment
Share on other sites

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. 

Link to comment
Share on other sites

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...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



×
×
  • Create New...