• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VLookup + Countif + Sum

Status
Not open for further replies.
RTowles

RTowles

Member
PLEASE DISREGARD. I READY BLUESKY63'S RESPONSE TO ANOTHER COUNTIF THREAD AND MODIFIED HIS FORMULA TO WORK FOR ME. BASICALLY I JUST NEEDED SUMIF.

I WOULD DELETE THIS BUT DO NOT KNOW HOW. SORRY​

Hi - I'm not sure if what I'm trying to do makes sense.

I have a list of random fruit. I have another list that tells me how many times that fruit comes up. I have another list (this is where I struggle) that'll tell me how many times a certain "brand" of fruit comes up.

In the attachment:
Column A holds the random fruit.
Column C calculates how many of each fruit.
Column F I want to tell me how many times an "OTC - over the counter" fruit was picked and calculate the total amount.

If I use COUNTIF(C4:D10, "*OTC*") it'll only tell me how many times OTC appeared in the list.
I want the formula to look and see Apple - OTC was picked 1, Grape - OTC was picked 1, Strawberry - OTC was picked 4, and Blueberry - OTC was picked 1, and give me the total of 7.

Please advise.
 

Attachments

  • Fruit Count.xlsx
    16.1 KB · Views: 3
Last edited:
Hi,
Try
=COUNTIF($A$3:$A$14,"*"&"OTC")

and for col D, use =COUNTIF($A$3:$A$14,C4) will do
 

Attachments

  • Fruit Count_Chris.xlsx
    22.7 KB · Views: 2
Status
Not open for further replies.
Back
Top