Page 1 of 1

[Solved] Get a sum of numbers within a specific range

PostPosted: Sun May 02, 2021 6:13 pm
by eng215
I am trying to get the sum of all numbers in a column that are less than 38

A1 = 5
A2 = 40
A3 = 3
A4 = 4
A5 = 50

The answer should be 12

Re: How to get a sum of numbers within a specific range

PostPosted: Sun May 02, 2021 6:29 pm
by Zizi64
Study and use the SUMIF() function.

Re: How to get a sum of numbers within a specific range

PostPosted: Sun May 02, 2021 6:45 pm
by Villeroy