Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF and VLookup
Any help is greatly appreciated.
In column S, I have either a D, a C, or a blank. Below my data I am trying to perform the sum function for all the amounts in column R that have a D in column S and a sum for all the amounts in column R that have a C in column S. Is it possible to combine the SUM and IF/VLookup functions? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF and VLookup
You don't need lookup. Try this:
=SUMIF(S:S,"D",R:R) =SUMIF(S:S,"C",R:R) HTH, Paul "Ashley" wrote in message ... Any help is greatly appreciated. In column S, I have either a D, a C, or a blank. Below my data I am trying to perform the sum function for all the amounts in column R that have a D in column S and a sum for all the amounts in column R that have a C in column S. Is it possible to combine the SUM and IF/VLookup functions? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF and VLookup
=SUMIF(S1:S100,"D",R1:R100)
=SUMIF(S1:S100,"C",R1:R100) "Ashley" wrote: Any help is greatly appreciated. In column S, I have either a D, a C, or a blank. Below my data I am trying to perform the sum function for all the amounts in column R that have a D in column S and a sum for all the amounts in column R that have a C in column S. Is it possible to combine the SUM and IF/VLookup functions? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF and VLookup
=SUMPRODUCT((D1:D10={"D","C",""})*(R1:R10))
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Ashley" wrote in message ... Any help is greatly appreciated. In column S, I have either a D, a C, or a blank. Below my data I am trying to perform the sum function for all the amounts in column R that have a D in column S and a sum for all the amounts in column R that have a C in column S. Is it possible to combine the SUM and IF/VLookup functions? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF and VLookup
or even
=SUMPRODUCT(SUMIF(D1:D10,{"C","D",""},R1:R10)) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Ashley" wrote in message ... Any help is greatly appreciated. In column S, I have either a D, a C, or a blank. Below my data I am trying to perform the sum function for all the amounts in column R that have a D in column S and a sum for all the amounts in column R that have a C in column S. Is it possible to combine the SUM and IF/VLookup functions? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF and VLookup
Thank you! I completely forgot about SUMIF
"Teethless mama" wrote: =SUMIF(S1:S100,"D",R1:R100) =SUMIF(S1:S100,"C",R1:R100) "Ashley" wrote: Any help is greatly appreciated. In column S, I have either a D, a C, or a blank. Below my data I am trying to perform the sum function for all the amounts in column R that have a D in column S and a sum for all the amounts in column R that have a C in column S. Is it possible to combine the SUM and IF/VLookup functions? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF and VLookup
Thank you! I completely forgot about SUMIF
"PCLIVE" wrote: You don't need lookup. Try this: =SUMIF(S:S,"D",R:R) =SUMIF(S:S,"C",R:R) HTH, Paul "Ashley" wrote in message ... Any help is greatly appreciated. In column S, I have either a D, a C, or a blank. Below my data I am trying to perform the sum function for all the amounts in column R that have a D in column S and a sum for all the amounts in column R that have a C in column S. Is it possible to combine the SUM and IF/VLookup functions? |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF and VLookup
Hi Ashley,
With an array formula ( Ctrl+Shift+Enter and not just Enter ) adjust ranges to your needs ... =SUM(IF(S2:S20="D",R2:R20)) HTH Cheers Carim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup a Vlookup | Excel Worksheet Functions | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |