If Column A>0 and Column B>0, Sum Column A?

[Av8nGirl]

Hi everyone, I am new to this forum (and making formulas) and hope that someone might be able to help with a formula I have been trying to create.

I have been keeping a spreadsheet for the last few years of all my flight times and need to get specific totals from columns I already have. For example, I want totals of Dual XC Instruction received, however I do not have a specific column for that. What I was trying to do to get this total is if Column L (XC) has a value >0, and Column N(Dual) has a value >0, I want it to show the sum of Column L.

This is what I came up with but it keeps giving an error.
{=SUM(IF((L650:L676>0)*(N650:N676>0),L650:L676))}

I attached a small example of what the spreadsheet looks like.

Thanks in advance for any help.

[edvwvw]

The reason that you are getting an error is that you are including the column L that you are trying to amend. Can you use a helper cell?

edvwvw

[ChemistB]

As you are using Excel 2007, you can utilize SUMIFS

Try
=SUMIFS(L650:L676,L650:L676, ">0", N650:N676, ">0")
Does that work for you?

[Haseeb Avarakkan]

Hello, use

=SUMIF(N650:N676,">0",L650:L676)

[Av8nGirl]

As you are using Excel 2007, you can utilize SUMIFS

Try
=SUMIFS(L650:L676,L650:L676, ">0", N650:N676, ">0")
Does that work for you?

Thanks! That worked and I was able to use the format for a few others that I needed.

However, now I ran into the issue if I had 3 columns with an OR situation. Can that be done with SumIfs? If I can figure that out, then I think my spreadsheet will be finished Any help with be much appreciated.

I attached another example of what I need for the formula below.

If column E OR column F is >0, AND column N >0, then sum column N.

[ChemistB]

Try this

=SUMPRODUCT(--(($E$4:$E$600+$F$4:$F$600)>0),$N$4:$N$600)

Does that work for you?

[Av8nGirl]

Try this

=SUMPRODUCT(--(($E$4:$E$600+$F$4:$F$600)>0),$N$4:$N$600)

Does that work for you?

I think that works! Thank you so much