SumIf Help

  • Thread starter Thread starter parteegolfer
  • Start date Start date
P

parteegolfer

I am looking to use the and command along with SumIf command to check
the conditions of two columns. If the two columns are true sum up the
columns that are true.


Example: SumIf(And(C7:C400="",G7:G400>1 then sum D7:D400)

Can someone help with the correct formula!

Thanks
 

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

SUMIF with criteria "<>" & "=" 4
Using Sumifs 3
insert new row and copy formula 1
SUMIF with 2 conditions 20
SUMIF() to add cells in non-contiguous ranges? (Excel 2003) 4
Can I have two conditions in a SUMIF? 5
SUMIF formula with non contiguous cells 2
subtotal with sumif nested 1

Back
Top