| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match data, count data and report to diffrent sheet.
I have a work sheet that I want to report to another page. I am putting
togehter a production tracking tool, and need to pull information from two diffren colums in the work sheet and count them. Basically what I want is to be able to if v2:V690 = 8386 and r2:r690 = 1/20/09 then count 1 for every time it happes in the same row. I've tried this several diffrent was if then, count, sum, what am I doing wrong and how do I do it right. this was the last effort =COUNTIFS(IF(LCR!V2:V690,B4),(LCR!R2:R690,G3)) Please help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Report data from cell if dates match | Excel Discussion (Misc queries) | |||
| Report data from cell if dates match | Excel Discussion (Misc queries) | |||
| Report data from cell if dates match | Excel Discussion (Misc queries) | |||
| Report data from cell if dates match | Excel Discussion (Misc queries) | |||
| match data to another sheet and return all the data on that row | Excel Worksheet Functions | |||
Threaded Mode
