| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if then statement based on another column
i'm trying to use this formula =SUMIF(B1:B200,"<sent",A1:A200)
if column C is one of 4 statements. how do i use both? for example, if column c is "A" then SUMIF(B1:B200,"<sent",A1:A200) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if then statement based on another column
I provided you with an answer to this same question 12 minutes before you
repeat-posted here again, in as a new thread. In the future, please stay with your original thread for follow ups and, by all means, check the responses you get to your original questions. Rick "Ann" wrote in message ... i'm trying to use this formula =SUMIF(B1:B200,"<sent",A1:A200) if column C is one of 4 statements. how do i use both? for example, if column c is "A" then SUMIF(B1:B200,"<sent",A1:A200) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if then statement based on another column
sorry, i messed up. i had already posted your response answered my question,
but then had a follow up. sorry again. "Rick Rothstein (MVP - VB)" wrote: I provided you with an answer to this same question 12 minutes before you repeat-posted here again, in as a new thread. In the future, please stay with your original thread for follow ups and, by all means, check the responses you get to your original questions. Rick "Ann" wrote in message ... i'm trying to use this formula =SUMIF(B1:B200,"<sent",A1:A200) if column C is one of 4 statements. how do i use both? for example, if column c is "A" then SUMIF(B1:B200,"<sent",A1:A200) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if then statement based on another column
Ann,
Maybe SUMPRODUCT is what you want: =SUMPRODUCT(--(C1:C200="A"),--(B1:B200<"sent"),A1:A200) HTH, Paul -- "Ann" wrote in message ... i'm trying to use this formula =SUMIF(B1:B200,"<sent",A1:A200) if column C is one of 4 statements. how do i use both? for example, if column c is "A" then SUMIF(B1:B200,"<sent",A1:A200) |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if then statement based on another column
this helps. another follow up - what if it it's "A" or "B". i can't get the
syntax right. "PCLIVE" wrote: Ann, Maybe SUMPRODUCT is what you want: =SUMPRODUCT(--(C1:C200="A"),--(B1:B200<"sent"),A1:A200) HTH, Paul -- "Ann" wrote in message ... i'm trying to use this formula =SUMIF(B1:B200,"<sent",A1:A200) if column C is one of 4 statements. how do i use both? for example, if column c is "A" then SUMIF(B1:B200,"<sent",A1:A200) |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if then statement based on another column
Try this:
=SUMPRODUCT(--(C1:C200="A")+(C1:C200="B"),--(B1:B200<"sent"),A1:A200) Regards, Paul -- "Ann" wrote in message ... this helps. another follow up - what if it it's "A" or "B". i can't get the syntax right. "PCLIVE" wrote: Ann, Maybe SUMPRODUCT is what you want: =SUMPRODUCT(--(C1:C200="A"),--(B1:B200<"sent"),A1:A200) HTH, Paul -- "Ann" wrote in message ... i'm trying to use this formula =SUMIF(B1:B200,"<sent",A1:A200) if column C is one of 4 statements. how do i use both? for example, if column c is "A" then SUMIF(B1:B200,"<sent",A1:A200) |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if then statement based on another column
this works, thanks!
"PCLIVE" wrote: Try this: =SUMPRODUCT(--(C1:C200="A")+(C1:C200="B"),--(B1:B200<"sent"),A1:A200) Regards, Paul -- "Ann" wrote in message ... this helps. another follow up - what if it it's "A" or "B". i can't get the syntax right. "PCLIVE" wrote: Ann, Maybe SUMPRODUCT is what you want: =SUMPRODUCT(--(C1:C200="A"),--(B1:B200<"sent"),A1:A200) HTH, Paul -- "Ann" wrote in message ... i'm trying to use this formula =SUMIF(B1:B200,"<sent",A1:A200) if column C is one of 4 statements. how do i use both? for example, if column c is "A" then SUMIF(B1:B200,"<sent",A1:A200) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple If Then Statement based on ranges | Excel Worksheet Functions | |||
| MSGBox based on If Statement | Excel Discussion (Misc queries) | |||
| Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
| If Statement based on blank fields | Excel Worksheet Functions | |||
| Msgbox based on If statement | Excel Worksheet Functions | |||
Hybrid Mode
