| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if then count sum
i need to count the sum of values in column A if column B < "sent" ... sent
is text written into the cell thanks in advance. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if then count sum
Give this a try...
=SUMIF(B1:B200,"<sent",A1:A200) Adjust the ranges to suit your needs. Rick "Ann" wrote in message ... i need to count the sum of values in column A if column B < "sent" ... sent is text written into the cell thanks in advance. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if then count sum
had a follow up.
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 count sum
For future reference, you should always ask the question you want an answer
to, not a simplified version of it... the answers to them will almost always be different. I'm not sure what you mean by "C is one of 4 statements", but going with your example of Column C containing an "A" and Column B does not contain "sent", this formula will count add up the values from Column A where both of those statements are true for the same row... =SUMPRODUCT((B1:B200<"sent")*(C1:C200="A")*A1:A20 0) Rick "Ann" wrote in message ... had a follow up. 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 count sum
Do you mean
=IF(OR(C2="A",C2="B",C2="C",C2="D"),SUMIF(B1:B200, "<sent",A1:A200),"") -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Ann" wrote in message ... had a follow up. 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 count sum
sorry you are correct, i have misposted this question in this thread and in
the other one i started. i apologize and thank you for your help. =SUMPRODUCT(--(H3:H200="AA 250"),--(F3:F200<"sent"),E3:E200) i want to add in "AA 250" or "AA 251" for this statement as the sum of these should be together, the rest I've got. thanks again. "Bob Phillips" wrote: Do you mean =IF(OR(C2="A",C2="B",C2="C",C2="D"),SUMIF(B1:B200, "<sent",A1:A200),"") -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Ann" wrote in message ... had a follow up. 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 count sum
ok, i've got it, thank you so much.
"Ann" wrote: sorry you are correct, i have misposted this question in this thread and in the other one i started. i apologize and thank you for your help. =SUMPRODUCT(--(H3:H200="AA 250"),--(F3:F200<"sent"),E3:E200) i want to add in "AA 250" or "AA 251" for this statement as the sum of these should be together, the rest I've got. thanks again. "Bob Phillips" wrote: Do you mean =IF(OR(C2="A",C2="B",C2="C",C2="D"),SUMIF(B1:B200, "<sent",A1:A200),"") -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Ann" wrote in message ... had a follow up. 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) |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if then count sum
=SUMPRODUCT(--((H3:H200="AA 250")+(H3:H200="AA
251")),--(F3:F200<"sent"),E3:E200) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Ann" wrote in message ... sorry you are correct, i have misposted this question in this thread and in the other one i started. i apologize and thank you for your help. =SUMPRODUCT(--(H3:H200="AA 250"),--(F3:F200<"sent"),E3:E200) i want to add in "AA 250" or "AA 251" for this statement as the sum of these should be together, the rest I've got. thanks again. "Bob Phillips" wrote: Do you mean =IF(OR(C2="A",C2="B",C2="C",C2="D"),SUMIF(B1:B200, "<sent",A1:A200),"") -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Ann" wrote in message ... had a follow up. 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) |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if then count sum
A minor point, but are you sure that you need the double unary minus on the
column H term? Doesn't the addition do the job of coercing to a number? -- David Biddulph "Bob Phillips" wrote in message ... =SUMPRODUCT(--((H3:H200="AA 250")+(H3:H200="AA 251")),--(F3:F200<"sent"),E3:E200) "Ann" wrote in message ... sorry you are correct, i have misposted this question in this thread and in the other one i started. i apologize and thank you for your help. =SUMPRODUCT(--(H3:H200="AA 250"),--(F3:F200<"sent"),E3:E200) i want to add in "AA 250" or "AA 251" for this statement as the sum of these should be together, the rest I've got. thanks again. "Bob Phillips" wrote: Do you mean =IF(OR(C2="A",C2="B",C2="C",C2="D"),SUMIF(B1:B200, "<sent",A1:A200),"") -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Ann" wrote in message ... had a follow up. 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) |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if then count sum
David,
What the heck is a "double uanry minus" and what does it do? -- Sociopath "David Biddulph" wrote: A minor point, but are you sure that you need the double unary minus on the column H term? Doesn't the addition do the job of coercing to a number? -- David Biddulph "Bob Phillips" wrote in message ... =SUMPRODUCT(--((H3:H200="AA 250")+(H3:H200="AA 251")),--(F3:F200<"sent"),E3:E200) "Ann" wrote in message ... sorry you are correct, i have misposted this question in this thread and in the other one i started. i apologize and thank you for your help. =SUMPRODUCT(--(H3:H200="AA 250"),--(F3:F200<"sent"),E3:E200) i want to add in "AA 250" or "AA 251" for this statement as the sum of these should be together, the rest I've got. thanks again. "Bob Phillips" wrote: Do you mean =IF(OR(C2="A",C2="B",C2="C",C2="D"),SUMIF(B1:B200, "<sent",A1:A200),"") -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Ann" wrote in message ... had a follow up. 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) |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if then count sum
Bob Phillips explains =sumproduct() in much more detail he
http://www.xldynamic.com/source/xld.SUMPRODUCT.html And J.E. McGimpsey has some notes at: http://mcgimpsey.com/excel/formulae/doubleneg.html SwearBear wrote: David, What the heck is a "double uanry minus" and what does it do? -- Sociopath "David Biddulph" wrote: A minor point, but are you sure that you need the double unary minus on the column H term? Doesn't the addition do the job of coercing to a number? -- David Biddulph "Bob Phillips" wrote in message ... =SUMPRODUCT(--((H3:H200="AA 250")+(H3:H200="AA 251")),--(F3:F200<"sent"),E3:E200) "Ann" wrote in message ... sorry you are correct, i have misposted this question in this thread and in the other one i started. i apologize and thank you for your help. =SUMPRODUCT(--(H3:H200="AA 250"),--(F3:F200<"sent"),E3:E200) i want to add in "AA 250" or "AA 251" for this statement as the sum of these should be together, the rest I've got. thanks again. "Bob Phillips" wrote: Do you mean =IF(OR(C2="A",C2="B",C2="C",C2="D"),SUMIF(B1:B200, "<sent",A1:A200),"") -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Ann" wrote in message ... had a follow up. 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) -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
| Excel 2000, count, sort a list & count totals? | Excel Worksheet Functions | |||
| How do i count numbers and letters to find a total count of all | Excel Worksheet Functions | |||
| Count Intervals of 2 Numeric values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Linear Mode
