SOLVED

Contributor

# SUM UP THE VALUES IN THE COLUMNS

Hello,

I have attached a file. i have to sum up the value. can you please check the sample file?

6 Replies
best response confirmed by najim_uddin (Contributor)
Solution

# Re: SUM UP THE VALUES IN THE COLUMNS

That looks like homework.

Which means you are supposed to come up with the solutions/formulas.

However, I will give you a hint: SUMIFS().

# Re: SUM UP THE VALUES IN THE COLUMNS

a.)

``=COUNTIF(B10:B52,"Central")``

b.)

``=COUNTIFS(D10:D52,"Pencil",B10:B52,"East")+COUNTIFS(D10:D52,"Pencil",B10:B52,"West")``

c.)

``=SUMIF(C10:C52,"Kivell",G10:G52)``

d.) (Update: Correction)

``=COUNTIF(C10:C52,"Jardine")``

# Re: SUM UP THE VALUES IN THE COLUMNS

@dscheikey, COUNTIF doesn't work here, and FILTER options too. as I am using a older version of Excel. Btw. it solved with SUMIFS function.

# Re: SUM UP THE VALUES IN THE COLUMNS

@Detlef Lewin Thanks, it works. its not homework. The file I found from a YouTube link for practice.

# Re: SUM UP THE VALUES IN THE COLUMNS

It's  the same. If you want to practice then YOU have to come up with the solutions and not someone else.

# Re: SUM UP THE VALUES IN THE COLUMNS

I am surprised that you can achieve a solution with SUMIFS() but cannot work with COUNTIF(). These are both very old functions that have been introduced since 2013. The versions with only one criterion SUMIF() or COUNTIF() already exist since EXCEL version 2007.

Never mind! In d.) I seem to have misunderstood the question. The answer 3 was three different products bought from "Jardine".