Adding Up cells in one colum IF cell in another column is yes

  • Thread starter Thread starter HKW
  • Start date Start date
H

HKW

Hi

I have a spreadsheet and I want to add up the number of cells in one column
if the cells in another column equal 1.

I have 800-odd grid references down the page and various columns across -
some are "items" and some are "conditions". I want to know how many grid
references have one particular item that also have one particular condition.
Does that make sense? If anyone can even point me in the right direction
that'd be great.

Thanks
 
If column a contains the 1's and column B contains the values

=SUMIF(A1:A800,1,B1:B800)

should suffice

Regards

Dav
 

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

Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Copy corresponding cell in Column B if cell in A contains certain text? 1
Conditional Cell Formatting 5
my formated column is displaying one cell incorrectly 2
Conditional format a column based on value in a different column 3
See if cell value appears within a value range given by another cell. 9

Back
Top