Sum(if

[jkktx81]

I have having trouble getting a new spreadsheet to work, with what i think I'm using same type of formula on.

{=SUM(IF(JAN!E8:E37=C5,IF(JAN!G8:G37=A5,JAN!O8)))}

In this, one sheet is totaling from another depending on criteria.

Only think I know is the JAN!O8 cell has formula in it to sum numbers; could this cause my problem and or what coould I do to make it work for me?

I'm getting a #NA

 

[ghard1]

I have having trouble getting a new spreadsheet to work, with what i think I'm using same type of formula on.

{=SUM(IF(JAN!E8:E37=C5,IF(JAN!G8:G37=A5,JAN!O8)))}

In this, one sheet is totaling from another depending on criteria.

Only think I know is the JAN!O8 cell has formula in it to sum numbers; could this cause my problem and or what coould I do to make it work for me?

I'm getting a #NA

The formula looks right to me at first glance. Is the worksheet tab JAN? or JAN!? It should be JAN by your formula. Also, tab names are case sensitive so I'd make sure you typed it correctly. I've made this mistake in the past.

 

[T. Valko]

I have having trouble getting a new spreadsheet to work, with what i think I'm using same type of formula on.

{=SUM(IF(JAN!E8:E37=C5,IF(JAN!G8:G37=A5,JAN!O8)))}

In this, one sheet is totaling from another depending on criteria.

Only think I know is the JAN!O8 cell has formula in it to sum numbers; could this cause my problem and or what coould I do to make it work for me?

I'm getting a #NA

The problem is that you're testing arrays in:

JAN!E8:E37=C5
JAN!G8:G37=A5

But the sum range is a single cell:

JAN!O8

Maybe this is what you had in mind...

Array entered**:

=SUM(IF(Jan!E8:E37=C5,IF(Jan!G8:G37=A5,Jan!O8:O37)))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

 

[jkktx81]

Thank you both. It worked for me this morning. Maybe it was the O8:O37 part. I thought I had tried that yesterday, but I probably didn't.

 

[T. Valko]

Thank you both. It worked for me this morning. Maybe it was the O8:O37 part. I thought I had tried that yesterday, but I probably didn't.

Good deal. Thanks for the feedback!