This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hello,
I am using Microsoft Excel office
I have created a spreadsheet for our banquet. I have a column which is labeled C3 to C44 and then C46 to C88.
I want to insert a formula in cell c90 that gives me the sum of all those who ordered Ham, and cell 91 for all those that ordered Turkey.
I have gone on line to try and find the formula that will do this. I have tried close to a dozen formulas and none of them give me the results I am looking for.
If anyone could send me a formula that works I would be greatly appreciative.
Thanks
Bill
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
In C90:
=COUNTIF(C3:C44,"Ham")+COUNTIF(C46:C88,"Ham")
In C91:
=COUNTIF(C3:C44,"Turkey")+COUNTIF(C46:C88,"Turkey")
P.S. If C45 will never contain "Ham" or "Turkey", you can use
=COUNTIF(C3:C88,"Ham")
=COUNTIF(C3:C88,"Turkey")
That worked perfectly. I plugged in the formulas and even added some and it works great.
Thank you very much.
Bill