Adding a certain number from a group of cells

  • Thread starter Thread starter eric7777
  • Start date Start date
E

eric7777

Hi everyone,

I have a formula question. I have different numbers in each cell
There are a lot of rows containing different numbers. I only want t
pick a certain number and have it add up. For example, cell A1=5
A2=65, A3=9, A4=145, A5=5, A6=547, A7=5, etc. I only want to pick th
cells that contain the number 5 and have a total. In this case i
would be 15. There are three cells with the number 5 and it adds up t
15. I need a formula that can find a certain number and totals it up.

eri
 
Hi Eric!

You can use the formula below to do this.
=SUMIF(A1:A7;5)

Stefan Hägglund
Microsoft
 
Back
Top