Adding values in an adjacent column?

  • Thread starter Thread starter lkiddo
  • Start date Start date
L

lkiddo

Hi All,

I'm new to Excel and would greatly appreciate it if some kind soul
would point me in the right direction...

I'm trying to create a table that adds values in column1 if the
adjacent field in column2 has a boolean.

I'm trying to make a simple calculator for hiding drives in our network
policy...

Here's a screenshot:

http://www.le0n.net/hmm.gif

This must be possible, but I don't have the knowledge/syntax to make it
work.

Many thanks,

Leon.
 
perhaps a look in the help index for the SUMIF function would be helpful
 
Thank you both Don and Bernard, for your quick replies. That's done the
trick. :-)
 
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

Counting unique values in multiple columns 4
"Group"ing adjacent columns independently 1
Matching the Searched Value to the Adjacent Column 1
Column groups adjacent to each other (with no column in between) 2
Identify adjacency cells with same value 3
Using =IF(B10<>"",COUNTA($B$10:B10),"") to number rows in columns other than A 2
Lookup using two values - like an SQL in the same workbook 4
How to Flag duplicate values in column 7

Back
Top