Hello everyone,
So I have this table I have made from my source information. Filtered out as much irrelevant information as I could and am left with this.
Now what I would like to do is find some way that I can count up each instance of Observation, Major, and Minor for each column and deposit them in their corresponding rows (J,K, and L) for quick counting. If someone could tell me how to do that I would greatly appreciate it.
Is Office version 2001 a MAC version?
I don't know if the function exists on that version but COUNTIFS would come in handy for this using the column header as the criterium to count.
Make sure you have a column for each of the options you want to count and in the cells below you can do the COUNTIFS and the column header as criterium
Hope it makes sens en if the '2001' supports that function
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
Thank you! I will look into this. I believe my excel version is 2016, I just had that set incorrectly.
Attach a sample file, makes it easier that me retyping your screenshot
Sure!
So I did what you said by using countif and it worked like a dream.
Great to hear, it's simpler than you think.
I'd just format those cells as non decimal number with a custom format like 0 ;; so the 0 values don't show, makes it faster to see
Don't forget to mark the post solved.
Happy coding
Originally Posted by Keebellah
Could you expand upon this? I'm pretty new so I don't understand. But that was my next goal, eliminating the 0's. Thank you again! You are a godsend.
I'v reattached your file , and please don't quote the post when answering, makes it messy.
I see that, but how did you remove all of the 0's?
Nevermind! I figured it out. Thank you.
One last question. As you've noticed in my data range I have 8A 8B etc. Is there a way to compile 8A 8B 10A 10B into a single cell with their values added together?
Check the cell formatting; you'll see it there
Probably , but add? what ? the numbers or the count of 8 , 10?
If it's just a part you can usein the countif as criterium with the double quotes.
Please Login or Register to view this content.
On the table I have two instances of 8 and two instances of 10 in the # row. What I would like to do is add the major, minor, and observation of those columns (and any column that have the same # value) so that when I graph them I don't have multiple 8's or 10's or whatever # is duplicated.
Last edited by MaxwellM; 06-08-2020 at 12:32 PM.
Maybe add helper columns?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks