| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif criteria "equal"
Hello, I want to search column A, if the values in column A are equal, I
want to sum the corresponding values in column D. I've tried the following formula and it does not work: =SUMIF(A5:A100,"=",D5:D100) Could someone offer a suggestion for the correct "criteria" value? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I link the "sumif" criteria to a cell? thks | Excel Discussion (Misc queries) | |||
| COUNTIF based on several criteria incl. a "does not equal" criteri | Excel Worksheet Functions | |||
| sort data rows "greater than or equal" criteria in another cell | Excel Worksheet Functions | |||
| How do I use the criteria "is not blank" in a SUMIF formula? | Excel Worksheet Functions | |||
| results of "SUMIF" test criteria | Excel Worksheet Functions | |||
Threaded Mode
