Mike "Wuzzy121". Rest in peace, brother

Go Back   Tacoma World Forums > Off-Topic > Technology

Notices

Excel Help!

Reply
 
Thread Tools Search this Thread
Old 06-07-2012, 12:16 PM   #1
bulhas [OP] bulhas is online now
the habs fan
bulhas is one of the sharper tools in the shedbulhas is one of the sharper tools in the shedbulhas is one of the sharper tools in the shedbulhas is one of the sharper tools in the shedbulhas is one of the sharper tools in the shedbulhas is one of the sharper tools in the shedbulhas is one of the sharper tools in the shedbulhas is one of the sharper tools in the shedbulhas is one of the sharper tools in the shedbulhas is one of the sharper tools in the shedbulhas is one of the sharper tools in the shed
 
bulhas's Avatar
Name: Joe
Joined: Dec 2010, #47857
Location: Edmonton, Alberta
Age: 28
Gender: Male
Posts: 5,152
bulhas's Tacoma Gallery
Excel Help!

I have a sheet I'm making and its an odd one, im close but I am not 100% there yet

What I am trying to do

Sheet 1

I have date in Row A and a tag in Row B, Sheet 2 i built a countif to count the amount each tags individually pop up

=SUM(COUNTIF('log take 1'!C:C,A2))

in order to that you can see i moved the individual tags in Row A ,now the next key in order to build a proper bar graph I need to know how many times each individual tag dropped on each day.....

i was trying a countifs but i cant seem to get anything but a sum of 0


im going try a filter but if anyone is up for a challenge have a whirl, ill upload an excel copy right away

ummm my excel file is too large, so if you want the sheet send me a pm with your email ill send a copy
  Reply With Quote
Old 06-07-2012, 04:26 PM   #2
There's an evil monkey in my truck
Evil Monkey is one of the sharper tools in the shedEvil Monkey is one of the sharper tools in the shedEvil Monkey is one of the sharper tools in the shedEvil Monkey is one of the sharper tools in the shedEvil Monkey is one of the sharper tools in the shedEvil Monkey is one of the sharper tools in the shedEvil Monkey is one of the sharper tools in the shedEvil Monkey is one of the sharper tools in the shedEvil Monkey is one of the sharper tools in the shedEvil Monkey is one of the sharper tools in the shedEvil Monkey is one of the sharper tools in the shed
 
Evil Monkey's Avatar
Navy: Tradevman (flight simulator tech), Aviation Electrician (F-14a), Computer Scientist(civ)
Name: Robert
Joined: Aug 2007, #2352
Location: Escondido, CA
Age: 52
Gender: Male
Posts: 8,212
Evil Monkey's Tacoma Gallery
From your formula, it looks like you're counting items in column C. So, "count if" the item in A2 is found in 'log take 1" column C. If nothing is in C (which you didn't mention), you'll get a 0.

Also, you don't need the sum function. The Countif function will return the number of cells that match your criteria.
  Reply With Quote
Old 06-07-2012, 09:01 PM   #3
bulhas [OP] bulhas is online now
the habs fan
bulhas is one of the sharper tools in the shedbulhas is one of the sharper tools in the shedbulhas is one of the sharper tools in the shedbulhas is one of the sharper tools in the shedbulhas is one of the sharper tools in the shedbulhas is one of the sharper tools in the shedbulhas is one of the sharper tools in the shedbulhas is one of the sharper tools in the shedbulhas is one of the sharper tools in the shedbulhas is one of the sharper tools in the shedbulhas is one of the sharper tools in the shed
 
bulhas's Avatar
Name: Joe
Joined: Dec 2010, #47857
Location: Edmonton, Alberta
Age: 28
Gender: Male
Posts: 5,152
bulhas's Tacoma Gallery
Quote:
Originally Posted by Evil Monkey View Post
From your formula, it looks like you're counting items in column C. So, "count if" the item in A2 is found in 'log take 1" column C. If nothing is in C (which you didn't mention), you'll get a 0.

Also, you don't need the sum function. The Countif function will return the number of cells that match your criteria.
log take 1 has data in in column C if it matches column A on sheet b it counts,

I built a pivot table and was able to decipher my issue, my only problem is i do not like the layout of pivot tables

I might build a filter array and than I may be able to get it to tell me which cells need to go where
  Reply With Quote
Old 06-07-2012, 10:03 PM   #4
Senior Member
wileyC is one of the sharper tools in the shedwileyC is one of the sharper tools in the shedwileyC is one of the sharper tools in the shedwileyC is one of the sharper tools in the shedwileyC is one of the sharper tools in the shedwileyC is one of the sharper tools in the shedwileyC is one of the sharper tools in the shedwileyC is one of the sharper tools in the shedwileyC is one of the sharper tools in the shedwileyC is one of the sharper tools in the shedwileyC is one of the sharper tools in the shed
 
wileyC's Avatar
Joined: Oct 2011, #65685
Location: Centerville, OH
Gender: Male
Posts: 2,767
wileyC's Tacoma Gallery
w/out seeing the spreadsheet in question, i don't know, ...but i will give some words of wisdom when scratching one's head over unexpected results in excel formulas:

- be weary of data (especially if imported or pasted from outside source), ...on several occasions i've seen where data will show up as expected in the cells, but in reality may contain a very minute difference from rounding or from some measurement... i.e. expecting to use formulas that will "work" assuming all your data are truely integers may not work right if some data have these minute rounding errors - this is because conditionals trying to compare two numbers to see if they are "equal" is interpreted literally..
  Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Experts out there? memario1214 Technology 25 11-08-2011 09:39 AM
iPad and Excel Mitch Technology 6 08-22-2011 10:24 AM
Help With Excel jdkeller Technology 8 01-10-2011 05:57 AM
Excel Gurus...Need your help... solus Technology 3 12-02-2010 09:00 PM
Help With Excel Spreadsheets AFButters Technology 4 05-20-2010 09:41 AM


Copyright © 2014 Tacoma Forum. Tacoma World is not owned by, or affiliated with Toyota Motor Corporation.