Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hello,
Thanks for the help. I need to count the data that was dumped into column A:C into L, M, N, and O. If the date of column A matches the date in column K and if the number in column B matches (say for this example) the number in column M I would like to pull the number from column C to column O. I showed in the tally how I would like the final product to look. Thanks for the help. Dump A B C 1/2/2005 1 95 2 96 1/3/2005 0 8 1 308 2 533 1/4/2005 0 7 1 211 2 383 Tally K L M N O 0 1 2 3 Sunday, January 02, 2005 95 96 Monday, January 03, 2005 8 308 533 Tuesday, January 04, 2005 7 211 383 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Forget SUMIF, COUNTIF and VLOOKUP | Excel Worksheet Functions | |||
Which formula to use? countif, sumif, sumproduct | Excel Discussion (Misc queries) | |||
problems with sumif and countif | Excel Discussion (Misc queries) | |||
SUMPRODUCT or SUMIF | Excel Worksheet Functions | |||
Sumif not Sumproduct | Excel Worksheet Functions |