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
Show the subnet address, subnet mask in slash notation, broadcast address, number of addresses, first valid host address, and th
sineoko [7]
Subnet 102.176.0.0/12
broadcast 102.191.255.255
lowest 102.176.0.1
highest 102.191.255.254
7 0
3 years ago
Which of the following best reflects why lighting systems are used when filming on location outdoors? (Select all that apply.)
cupoosta [38]
<h2>All the given answers are right</h2>

Explanation:

  • Lighting is one of the key factor which is essential to do cinematography
  • It will help to cut off the shadows that is created using natural light
  • It can depict the mood of the scene that is shoot
  • We can adjust manually brightness and darkness according to the need, which is not possible in the natural light.
  • It can boost the quality of the footage
  • We can shoot anytime irrespective of the weather condition
  • The light from the camera alone is not enough to shoot the best picture
8 0
3 years ago
QUESTION 1
slava [35]
Answer is Bit defender Internet security
B
6 0
2 years ago
A mail merge data source must contain
Katena32 [7]

Answer:

A. a collection of organized data.

Explanation:

It can be a data source, or a database, an excel sheet. or access database. However, it must be well-formatted and hence organized. filtering of data is not necessary, as well as it is not any barrier to the number of the set of data, or the data being sorted. Unsorted data is also fine, and multiple set of data is also fine. It must be known that a data source can be formed from multiple sets of data through the query. And the resultant data source can be used by the mail merge. However, the data source must be a collection of organized data. Hence, A is the correct answer.

5 0
3 years ago
This isn't about school but every time it tells me to watch an ad to unlock the answer to a question it prompts a survey and it
Masja [62]
Restart it than see what happens
4 0
3 years ago
Read 2 more answers
Other questions:
  • Given a computer running four types of instuctions, named classes A through D, calculate the execution time of a program that ha
    5·1 answer
  • If you wish to maintain a consistent style to all the documents you create, it would be helpful to use a _____.
    10·1 answer
  • Can someone please help me with this question??
    12·1 answer
  • Another html/css assignment, drop css code below, thank you
    15·1 answer
  • Visual imagery encoding relates to _____ encoding, in that a person is connecting the new information to previously existing inf
    11·1 answer
  • With which type of social engineering attack are users asked to respond to an email or are directed to a website where they are
    9·1 answer
  • D) Informal high level descuption of an algorithm in english kcalled
    9·2 answers
  • 5. In what ways is the human brain like a computer? In what ways is it different?
    15·2 answers
  • How to add a legend to a graph in excel?
    7·2 answers
  • What was one effect of better printing methods during the Ming Dynasty? Updated trade routes A new merchant class Increased lite
    14·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!