Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
dsum or sumif?
I would like to sum the if the column have 390, 710, 720 & G, should be dsum
or sumif? Also, i have been used sumif, it's seem too long, pls. advise any quickly methods? Pls. see the following details: Class No. of Request 1 5 155 2 391 1 200 4 715 2 720 3 AS 1 D 1 DE 2 The total for the Class (390, 71, 720 & D*) should be 4. Thanks!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
dsum or sumif?
Array function ( use Ctrl + Shift + Enter )
=SUM(IF(A2:A10={390,710,720,"g"},B2:B10)) On Jan 29, 11:46*am, ff wrote: I would like to sum the if the column have 390, 710, 720 & G, should be dsum or sumif? *Also, i have been used sumif, it's seem too long, pls. advise any quickly methods? *Pls. see the following details: Class * No. of Request 1 * * * 5 155 * * 2 391 * * 1 200 * * 4 715 * * 2 720 * * 3 AS * * *1 D * * * 1 DE * * *2 The total for the Class (390, 71, 720 & D*) should be 4. *Thanks!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
dsum or sumif?
You can use SUMPRODUCT
=SUMPRODUCT((A2:A10={390,710,720,"G"})*(B2:B10)) -- __________________________________ HTH Bob "ff" wrote in message ... I would like to sum the if the column have 390, 710, 720 & G, should be dsum or sumif? Also, i have been used sumif, it's seem too long, pls. advise any quickly methods? Pls. see the following details: Class No. of Request 1 5 155 2 391 1 200 4 715 2 720 3 AS 1 D 1 DE 2 The total for the Class (390, 71, 720 & D*) should be 4. Thanks!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dsum or SumIf | Excel Worksheet Functions | |||
Dsum or Sumif Help!!! | Excel Worksheet Functions | |||
I've tried DSUM, SUMIF.... | Excel Discussion (Misc queries) | |||
DSUM vs SUMIF | Excel Worksheet Functions | |||
formulas SUMIF & DSUM | Excel Discussion (Misc queries) |