SOLVED

SUM UP THE VALUES IN THE COLUMNS

Contributor

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

@najim_uddin 

That looks like homework.

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

 

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

 

@najim_uddin 

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")

 

 

@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.
@Detlef Lewin Thanks, it works. its not homework. The file I found from a YouTube link for practice.

@najim_uddin 

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

 

@najim_uddin 

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.

dscheikey_0-1664011735011.pngdscheikey_1-1664011804289.png

 

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