Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"if" function
I've got three columns
Column A Column B Column C L 5-Jan-2006 5,000 M 7-Jan-2006 100 L 1-Feb-2006 10,000 U 24-Mar-2006 10 Alpha code "L" 15,000 Function '=SUMIF(A2:A5,"L".C2:C5)' Alpha Code "L" in Jan (??? Function) How do I write the formula to get the alpha code L total for January? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
"if" function
=SUMPRODUCT(--(A2:A5="L"),--(MONTH(B2:B5)=1))
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "raf" wrote in message ... I've got three columns Column A Column B Column C L 5-Jan-2006 5,000 M 7-Jan-2006 100 L 1-Feb-2006 10,000 U 24-Mar-2006 10 Alpha code "L" 15,000 Function '=SUMIF(A2:A5,"L".C2:C5)' Alpha Code "L" in Jan (??? Function) How do I write the formula to get the alpha code L total for January? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
"if" function
On Sat 01/07/06 12:13:00, Bob Phillips wrote:
=SUMPRODUCT(--(A2:A5="L"),--(MONTH(B2:B5)=1)) Hi Bob, How do I get the total to equal to 5,000 for the month of January? Thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
"if" function
=SUMPRODUCT(--(A2:A5="L"),--(MONTH(B2:B5)=1),C2:C5)
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "raf" wrote in message ... On Sat 01/07/06 12:13:00, Bob Phillips wrote: =SUMPRODUCT(--(A2:A5="L"),--(MONTH(B2:B5)=1)) Hi Bob, How do I get the total to equal to 5,000 for the month of January? Thanks! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
"if" function
Hi Bob,
Thanks for the formula! It works great, just what I needed. "Bob Phillips" wrote: =SUMPRODUCT(--(A2:A5="L"),--(MONTH(B2:B5)=1),C2:C5) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Wild Characters in "IF" function | Excel Discussion (Misc queries) | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |