correct formula, but wrong answer

Question

Hello.

I am writing the right formula for SUMIF, but I am getting the wrong answer.

I am looking for the answer to this question:

Write the conditional formula that you would use in Excel to add up the total number of sales from those pets whose names begin with the letter J.

And this is the formula I am using following my table.

=SUMIF(D3:D12, "J*",A3:A12)

therefore, the answer is 0. And it should be 3.

Answer 1

I created a different excel sheet, and still 0

Please help me and let me know how I can get the right answers.

Thank you

Answer 2

Hi respected Adela Sisoi,

Thanks for your valuable feedback and sharing updates with us and I really appreciate your effort and your precious time doing. 

And I appreciate your kind words.

Use below formula in your cell.

=COUNTIF(A3:A12,"J*")

.

=AVERAGEIF(B3:B12,">4")

.

Your understanding and patience will be highly appreciated. I hope that you are keeping safe and well!

Sincerely,

Waqas Muhammad

Answer 3

> SUMIF(D3:D12, "J*", A3:A12)

If I am not mistaken, your D and E columns are backwards.

SUMIF( A3:A12, "J*", ...etc)

or better.. use range names:

=SUMIF(Pet_Name, "J*", N_Sales)

Answer 4

Hello,

This is the table

Please help me how to use the formula to get the right answer.

And please help me with this question as well as it doesn’t work.

Question

Write the conditional formula that you would use in Excel to find the average income from sales from those pets whose names have more than 4 letters.

The answer here should be 6, but it’s saying 5.

Answer 5

Dear respected Adela Sisoi,

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

I’m sorry you’re having a problem but based on your description we can work together to resolve it.

For the situation you encountered, we deeply understand the inconvenience caused and apologize for it.

As per your description, firstly may I know does your range"D3:D12" is a pet's name or sales range? I think you are using the wrong range for the criteria argument in your SUMIF formula. You should use the range that contains the pet names, not the sales numbers.

=SUMIF (range, criteria, [sum_range])

=SUMIF(A1:A7, "J*",D1:D7)

This formula will sum the values in the range D1:D7, where the corresponding cells in the range A1:A7 begin with the letter J. The answer should be 3, as there are three pets whose names start with J: Jack, Jill, and Jumbo.

![](https://learn-attachment.microsoft.com/api/attachments/6b8a75e1-eae5-4655-b7bf-d3facfdeb18a?platform=QnA"https://learn-attachment.microsoft.com/api/attachments/78cd1e7f-afb9-4274-89a1-c7b0c15874be?platform=QnA" title="filestore.community.support.microsoft.com" rel="ugc nofollow">

.

Appreciate your patience and understanding and thank you for your time and cooperation.

Sincerely,

Waqas Muhammad