If Statements again

  • Thread starter Thread starter marksuza
  • Start date Start date
M

marksuza

Sorry, I guess the table I tried to recreate to better explain what
meant did not work.

I have 4 columns of which 3 are checkboxes (Pending, NY and LA), th
other column is 'Amount'. I have about 20 rows. At the bottom of th
sheet I have two boxes I created: 'NY Pending amount' and 'LA pendin
amount'

What I want is to sum all the pending NY amounts and all the pending L
amount. What I tried to do for example was 'If' Pending was 'true'
'sumif' all the 'true' NY, did not work though.

Sory for the bad explanation.

Marco
 

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

if statements 3
Sumproduct and if statements 4
Excel Is it possible to ask a question within a question? 0
VBA- IF statement to replace cell contents 0
"Count If" 3 criterias are fulfilled 2
Tricky Sheet Reference of Death. part I 5
Conditional Formating multible if statements 4
Formula Question 1

Back
Top