| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Argument description
What does
=+SUMIF($G10:$G31,"Yes",I10:I31) mean? -- steve |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Argument description
=SUMIF($G10:$G31,"Yes",I10:I31)
(You don't need the + Look at each cell in G10 to G31 (all 22 cells) If the value in each cell is Yes, then add up the value in the corresponding cell in column I (I10:I31) steve wrote: What does =+SUMIF($G10:$G31,"Yes",I10:I31) mean? -- steve -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Argument description
SUM I10:I31 if G10:G31 = "Yes"
-- Jacob (MVP - Excel) "steve" wrote: What does =+SUMIF($G10:$G31,"Yes",I10:I31) mean? -- steve |
|
#4
|
|||
|
|||
Quote:
http://www.techonthenet.com/excel/formulas/sumif.php all the best
__________________
Thanks Bala |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =IF(AND(' Job Duties Description'!S50,' Job Duties Description'!S5 | Excel Discussion (Misc queries) | |||
| COMPLETE DESCRIPTION | Excel Discussion (Misc queries) | |||
| Help and description for UDFs | Excel Worksheet Functions | |||
| Parameter description | Excel Worksheet Functions | |||
| Description box in excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
