Function question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have five consecutive cells in a row containing numeric values which I wish
to be summed up as a total in a sixth cell. I only want to add up those which
are above a certain value and ignore (but show in the cells) those which are
below the certain value.

tia
 
Assuming, for example, you want to sum up cells whose value is greater
than 5, try...

=SUMIF(A1:A5,">5")

or

=SUMIF(A1:A5,">"&B1)

....where B1 contains the number 5.

Hope this helps!
 
Use

=SUMIF(range of cells, ">3") - replacing 3 with whatever your threshold is
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Simple - F9, then K9, then, P9, then U9, etc... 18
Finding location (or start cell) of highest consecutive values 3
Problem with LARGE function 3
SUM function that ignores "#VALUE" and error entries?? 2
XL2002 SUM with a twist... 4
Data Validation - Complex Q 2
complex sort search and replace macro 2
will a function do this for me? 1

Back
Top