| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Multiple SumIf Formula
I need a formula allowing recognition of one response in
Cell A in addition to recognising if the answers in cell B equals either x, y or z then add up the total values. I understood the inclusion of the "+" symbol should allow this but my query parameters are not working. Eg: =SUM(IF(A5:A30="JUL",IF(D5:D30="HSP3")+ (D5:D30="HSP1",C5:C30)) So with this formula cells A should equal Jul and cells D have either HSP3 or HSP1. Thanks. |
|
#2
|
|||
|
|||
|
Invoking a SumProduct formula...
=SUMPRODUCT(--(A5:A30="JUL"),(D5:D30="HSP3")+(D5:D30="HSP1"),C5: C30) which just needs enter. Rose wrote: I need a formula allowing recognition of one response in Cell A in addition to recognising if the answers in cell B equals either x, y or z then add up the total values. I understood the inclusion of the "+" symbol should allow this but my query parameters are not working. Eg: =SUM(IF(A5:A30="JUL",IF(D5:D30="HSP3")+ (D5:D30="HSP1",C5:C30)) So with this formula cells A should equal Jul and cells D have either HSP3 or HSP1. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to return cell contents based on multiple conditions | Excel Worksheet Functions | |||
| select multiple cell ranges in "sumif" formula? | Excel Worksheet Functions | |||
| Sum(if ... multiple conditions ... Interpretation? | Excel Discussion (Misc queries) | |||
| How do I ask for multiple criteria when creating a "sumif" formul. | Excel Worksheet Functions | |||
| sumif to add data in multiple sheets | Excel Worksheet Functions | |||
Hybrid Mode
