PC Review


Reply
Thread Tools Rate Thread

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

 
 
HKW
Guest
Posts: n/a
 
      22nd Feb 2006
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
 
Reply With Quote
 
 
 
 
Dav
Guest
Posts: n/a
 
      22nd Feb 2006

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

 
Reply With Quote
 
HKW
Guest
Posts: n/a
 
      22nd Feb 2006
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
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
adding two colum cells only if there is data in 3rd colum stbob Microsoft Excel Worksheet Functions 1 30th Oct 2009 05:48 AM
Compare text string of a cell in Column A VS another cell in Colum =?Utf-8?B?VGFu?= Microsoft Excel New Users 2 1st Aug 2007 09:45 AM
Compare text string of a cell in Column A VS another cell in Colum =?Utf-8?B?VGFu?= Microsoft Excel Misc 1 1st Aug 2007 09:03 AM
Compare text string of a cell in Column A VS another cell in Colum =?Utf-8?B?VGFu?= Microsoft Excel Worksheet Functions 1 1st Aug 2007 09:01 AM
Compare text string of a cell in Column A VS another cell in Colum =?Utf-8?B?VGFu?= Microsoft Excel Programming 0 30th Jul 2007 05:12 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:58 AM.