Sep 23 2022 06:21 AM
Hello,
I have attached a file. i have to sum up the value. can you please check the sample file?
Sep 23 2022 06:33 AM
SolutionThat looks like homework.
Which means you are supposed to come up with the solutions/formulas.
However, I will give you a hint: SUMIFS().
Sep 23 2022 06:44 AM - edited Sep 24 2022 02:44 AM
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")
Sep 23 2022 10:41 PM
Sep 23 2022 10:43 PM
Sep 23 2022 11:15 PM
It's the same. If you want to practice then YOU have to come up with the solutions and not someone else.
Sep 24 2022 02:40 AM
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".
Sep 23 2022 06:33 AM
SolutionThat looks like homework.
Which means you are supposed to come up with the solutions/formulas.
However, I will give you a hint: SUMIFS().