Array formula with multiple named ranges

[sabrinam]

I'm using the following array equation with these two named ranges and it works perfectly:

=SUM(IF(Sabrina_NGLTypeWell_Test1=D38),Sabrina_NGL_Test1))

The problem is, I need there to be more criteria within my equation and so I've made more named ranges, except as soon as I add another one using the following equation, it stops working and gives me the #VALUE error.

=SUM(IF(AND(Sabrina_NGLTypeWell_Test1=D38,Sabrina_NGLProduct_Test1=E38),Sabrina_NGL_Test1))

Any idea what I'm doing wrong? Or alternative solutions?

Thanks

[Jonmo1]

See solution I posted in your original thread
http://www.excelforum.com/excel-form...eria-help.html

[Richard Buttrey]

Hi try

=SUMIFS(Sabrina_NGL_Test1,Sabrina_NGLTypeWell_Test1,D38,Sabrina_NGLProduct_Test1,E38)

This isn't an array formula so no need for Ctrl Shift Enter

[Richard Buttrey]

@Sabrinam

Jonmo1 has just pointed out that this is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread. Please read the forum rules

Thread Closed.