Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi there, need to sum up totals in a column, with 2 or more criteria:
eg: A B C USD LONG 10 EUR SHORT 10 USD LONG 10 USD SHORT need to SUMIF if Column A is USD AND Column B is LONG..in this case to return 20 also maybe other columns with additional criteria...can it be extended? thanks! |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
=SUMPRODUCT(--(A2:A20="USD"),--(B2:B200="LONG),C2:C200)
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "kahuna" wrote in message ... Hi there, need to sum up totals in a column, with 2 or more criteria: eg: A B C USD LONG 10 EUR SHORT 10 USD LONG 10 USD SHORT need to SUMIF if Column A is USD AND Column B is LONG..in this case to return 20 also maybe other columns with additional criteria...can it be extended? thanks! |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
that A2:A20 should be A2:A200
(but you knew that!) "Bob Phillips" wrote in message ... =SUMPRODUCT(--(A2:A20="USD"),--(B2:B200="LONG),C2:C200) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "kahuna" wrote in message ... Hi there, need to sum up totals in a column, with 2 or more criteria: eg: A B C USD LONG 10 EUR SHORT 10 USD LONG 10 USD SHORT need to SUMIF if Column A is USD AND Column B is LONG..in this case to return 20 also maybe other columns with additional criteria...can it be extended? thanks! |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
But the OP might not :-)
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Bob Umlas" wrote in message ... that A2:A20 should be A2:A200 (but you knew that!) "Bob Phillips" wrote in message ... =SUMPRODUCT(--(A2:A20="USD"),--(B2:B200="LONG),C2:C200) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "kahuna" wrote in message ... Hi there, need to sum up totals in a column, with 2 or more criteria: eg: A B C USD LONG 10 EUR SHORT 10 USD LONG 10 USD SHORT need to SUMIF if Column A is USD AND Column B is LONG..in this case to return 20 also maybe other columns with additional criteria...can it be extended? thanks! |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
fantastic thanks, i don`t suppose you could satisfy my curiosity and show how
its doing that? is the -- making the paramenters negative so when they multiply you just get 1 to multiply the last column by? thanks again! "Bob Phillips" wrote: But the OP might not :-) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Bob Umlas" wrote in message ... that A2:A20 should be A2:A200 (but you knew that!) "Bob Phillips" wrote in message ... =SUMPRODUCT(--(A2:A20="USD"),--(B2:B200="LONG),C2:C200) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "kahuna" wrote in message ... Hi there, need to sum up totals in a column, with 2 or more criteria: eg: A B C USD LONG 10 EUR SHORT 10 USD LONG 10 USD SHORT need to SUMIF if Column A is USD AND Column B is LONG..in this case to return 20 also maybe other columns with additional criteria...can it be extended? thanks! |
#6
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
See http://www.xldynamic.com/source/xld.SUMPRODUCT.html for a detailed
explanation. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "kahuna" wrote in message ... fantastic thanks, i don`t suppose you could satisfy my curiosity and show how its doing that? is the -- making the paramenters negative so when they multiply you just get 1 to multiply the last column by? thanks again! "Bob Phillips" wrote: But the OP might not :-) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Bob Umlas" wrote in message ... that A2:A20 should be A2:A200 (but you knew that!) "Bob Phillips" wrote in message ... =SUMPRODUCT(--(A2:A20="USD"),--(B2:B200="LONG),C2:C200) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "kahuna" wrote in message ... Hi there, need to sum up totals in a column, with 2 or more criteria: eg: A B C USD LONG 10 EUR SHORT 10 USD LONG 10 USD SHORT need to SUMIF if Column A is USD AND Column B is LONG..in this case to return 20 also maybe other columns with additional criteria...can it be extended? thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sumif multiple criteria | Excel Worksheet Functions | |||
sumif using multiple criteria | Excel Discussion (Misc queries) | |||
Sumif with multiple criteria | Excel Worksheet Functions | |||
SUMIF with multiple criteria | Excel Discussion (Misc queries) | |||
SUMIF With Multiple Criteria | Excel Worksheet Functions |