## SumIF column a = X AND column b = Y OR Z

Source: Stackoverflow.com
Question!

I'm struggling to create a formula which sums Column C IF (Column A = [name]) AND (Column B = "Possible" OR "Proposed" OR "Committed").

`=SUM(SUMIFS(\$C:\$C,\$A:\$A,[name],\$B:\$B,{"Proposed","Possible","Committed"}))`

With some functions, e.g. `COUNTIF`, `SUMIF`, `COUNTIFS`, `SUMIFS`, you can get away with referencing entire columns with no detriment to performance, though not with functions which operate over arrays, such as `AGGREGATE`, `SUMPRODUCT`, and any construction requiring `CSE`.

Regards

By : XOR LX

Use SumProduct with as the or operator rather than * as the and operator. Something like this:

``````=SUMPRODUCT((\$A:\$A=[name])*((\$B:\$B="Proposed") (\$B:\$B="Possible") (\$B:\$B="Committed"))*(\$C:\$C))
``````

You can try the following formula

``=SUMPRODUCT((A:A=[name])*(((B:B="Possible") (B:B="Proposed") (B:B="Committed"))``
``` By : Karpak ```
``` This video can help you solving your question :) By: admin ```
``` Related Questions Calculating points from 0-10 for achived time Google Spreadsheet - Calculate Range of Rows Conditional cell formatting Convert an excel or spreadsheet column letter to its number in Pythonic fashion (adsbygoogle = window.adsbygoogle || []).push({}); In Excel, how to JOIN? How to utilize date add function in Google spreadsheet? Spreadsheet formula to gather all matches into one cell Compute subtotal rows in a spreadsheet IDE-like solution for Excel formulas (Not VBA) Creating a list of unique pairs from a list of multi-value combinations in a Google Spreadsheet Changing margins in a spreadsheet convert string to float inside a SUMIF function Calculate weekly and monthly total in spreadsheet Google Spreadsheet: Sum of row n through last row Adding to cell value based on last non-empty cell in column in Google Spreadsheet Importing and processing a spreadsheet on Google App Engine VLOOKUP with two criteria What is the closest function to INDEX( ,MATCH( in Google Apps? How to import excel file that attached in my google account into spreadsheet automatically? How to sum a row contains text, and each text is equal a given specific value in google spreadsheet ```
``` ```
``` About Us    Contact Us    Legal    feedback    Copyright © 2015 - All Rights Reserved - www.4answered.com ```