Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif, sumif, sumproduct - I dont know which to use
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif, sumif, sumproduct - I dont know which to use
=IF(AND(A2=K2,,B2=M2),C2,"")
in O2 -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Jim" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif, sumif, sumproduct - I dont know which to use
Try this in column O, adjusting ranges as necessary. =sumproduct(($A$1:$A$100=K1)*($B$1:$B$100=M1)*($C$ 1:$C$100)) -- Vito ------------------------------------------------------------------------ Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182 View this thread: http://www.excelforum.com/showthread...hreadid=497867 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif, sumif, sumproduct - I dont know which to use
Since your dates do not repeat, doing this would be difficult.
If you fill in the missing dates you can do it by formula, but it would be far easier to just create a pivot table with the dates as row headers, the 0,1,2 etc values as column headers, and the other numbers as your data values. Use Data- Pivot Table and Pivot Chart... and then follow the prompts "Jim" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |