| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Combining SUMPRODUCT with IF - help!
Help, please! I am summing alternate rows in a spreadsheet, e.g.
=SUMPRODUCT(--(MOD(ROW(F5:F306),2)=1),F5:F306) but I only want to include the rows where is a particular bit of text in Column C (in this case "GARD"): =SUMIF($C7:$C302,"GARD",G7:G302) Is there a formula which will add these selected rows only? Many thanks. |
|
#2
|
|||
|
|||
|
Quote:
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining Functions (Sumproduct and Countif) | Excel Worksheet Functions | |||
| Sumproduct with Condition OR Sumproduct with ADDRESS function - HE | Excel Discussion (Misc queries) | |||
| Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
| Combining 2 INDEX/MATCH eq'ns; also 2 Sumproduct eq'ns | Excel Worksheet Functions | |||
| Combining SUMPRODUCT and RANK functions | Excel Worksheet Functions | |||
Linear Mode
