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

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

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

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

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

should suffice

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=515277

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

Oh that's great thank you - didn't realise it was quite so easy! Thanks
again.



Dav wrote:
If column a contains the 1's and column B contains the values

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

should suffice

Regards

Dav