1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Elina [12.6K]
2 years ago
11

I am trying to sum up a set of data based on 2 criteria (needs to have "green" in column E, and "January 2020" in collum A). Col

umn D is the set of numbers I need to add. I am getting "Error, array arguments in SUMIFS are of different size.
Computers and Technology
1 answer:
trasher [3.6K]2 years ago
7 0

In summing the set of data using the 2 criteria, the best way to do it is to avoid the error is that On cell G16, one should type the formula "=SUMIF(G2:G11, ">=40")".

<h3>What is the code about?</h3>

In computing, Formulas seen  In Microsoft Excel are known to be employed to be able to generate some outcome or values to any cell.

Note that the formula need to begin with an equal sign. The formula that is written above has the function "SUMIF" that helps to give the  sum of numeric values as a result of the condition.

Learn more about  SUMIFS from

brainly.com/question/19595606

#SPJ1

You might be interested in
From the set ( 5 , 7 , 9 , 11 , 13 make the inequality w - 4 &lt; 8 true
Ksenya-84 [330]

Answer:

Explanation:

One group of students did an experiment to study the movement of ocean water. The steps of the experiment are listed below.

Fill a rectangular baking glass dish with water.

Place a plastic bag with ice in the water near the left edge of the dish.

Place a lighted lamp near the left edge of the dish so that its light falls directly on the plastic bag.

Put a few drops of ink in the water.

The student did not observe any circulation of ink in the water as expected because the experiment had a flaw. Which of these statements best describes the flaw in the experiment? (2 points)

Not enough ink was added.

Not enough water was taken.

The dish was too small for the experiment.

The lamp and the ice bag were at the same place.

7 0
3 years ago
Gina is upgrading your computer with a new processor. She installs the processor into your motherboard and adds the cooling syst
Setler [38]

Answer:

Option B is Correct.

Explanation:

Thermal paste is used in the CPU motherboard to reduce the heat.

Thermal paste is a heat observing coating that is used to make the system cool when it is heated much by working for a long time.

Thermal paste is also used in heat sink in CPU and CPU passes the air in the heat sink to make the temperature normal.

Thermal paste is very useful which installing any processor otherwise which running, the temperature will be increased in the absence of the thermal paste.

It is used to maintain the empty place between the motherboard and the processor.

7 0
3 years ago
Write a C++ line of code to declare a variable of type “double” that signifies the average of student grades, then initialize th
mamaluj [8]

The line of code required to assign a value of 50.00 to a variable of double data type in C++ can be written thus :

  • double average_student_grade = 50.00;

The declaration follows the format :

  • Data type
  • Variable name
  • Value

The data type which is first stated, the double data type are floating point (have decimals) numbers which have 64 bit precison(a precison of 15 decimal digits) as opposed to floats which have 32 bit precison (a precison of 7 decimal digits).

The variable name is the name to hold the value of average grade. This name depends on the preference of the programmer. However. It is advisable that variable names are relatable.

Therefore, variable declaration in C++ may follow the format data type then variable name then value.

Learn more :brainly.com/question/12908743

4 0
2 years ago
You just realized the turn signal on your vehicle is broken,
zimovet [89]

Answer:

c

Explanation:

7 0
4 years ago
USB flash drives are small portable units that are used to ____________files.
Juliette [100K]

Answer:D

Explanation: they do all of these

3 0
4 years ago
Read 2 more answers
Other questions:
  • What tool listed below will be the most useful for developing presentation content?
    10·2 answers
  • which of the following electromagnetic waves are not used for communication? a.gamma rays b.microwaves c.infrared waves d.radio
    5·1 answer
  • What are 3 websites that talk about density of different gases, density in air, behavior of different gases of earth, convection
    13·1 answer
  • Backlighting allows for maximum detail to be seen in the front of the object you are photographing.
    7·1 answer
  • Desmond must enter a long string of numbers (1 4 9 2 1 6 2 0 1 7 7 6) into an old computer every two hours or the computer will
    12·1 answer
  • How might an engineer test a computer chair for comfort?
    10·1 answer
  • What tool is provided in Windows to facilitate sharing data objects between applications and computers?
    8·1 answer
  • Help me decide this hurry
    12·1 answer
  • पुजवय<br>शब्दस्य<br>विरूदायक​
    7·1 answer
  • How is the architecture converted into software code? Elaborate the steps its passes through with help of examples / Diagram.
    15·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!