# Count formula with condition

121 Reputation points
2022-11-02T08:06:09.04+00:00

I have an Excel sheet and want to count cell B value with the condition of Cell A.
for example, I have data like that
cell A cell B cell C
how am use a formula to count google values in the entire sheet and also Facebook values with the required condition?
when cell c1 is equal to google it compare the value of cell C with cell A and count all value of cell B of Google.

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,693 questions

1. 24,056 Reputation points Microsoft Vendor
2022-11-03T07:20:43.943+00:00

Do you want to SUM the values in cell B?
You can try this formula:

``````=SUMPRODUCT((\$A\$1:\$A\$3=C1)*(\$B\$1:\$B\$3))
``````

If you want to Count the values in cell B, try this formula:

``````=SUMPRODUCT((\$A\$1:\$A\$3=C1)*(B1:B3>0)*1)
``````

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.