Forum Discussion
Solved
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?
That looks like homework.
Which means you are supposed to come up with the solutions/formulas.
However, I will give you a hint: SUMIFS().
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.
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".
That looks like homework.
Which means you are supposed to come up with the solutions/formulas.
However, I will give you a hint: SUMIFS().
- Detlef_Lewin Thanks, it works. its not homework. The file I found from a YouTube link for practice.
It's the same. If you want to practice then YOU have to come up with the solutions and not someone else.
