nesting sum(if( help...

[scott23]

Can someone help me with the syntax for this formula im getting the
wrong results for.


Im trying to create a sum(if formula that has multiple occurences but
also contains 'either' occurrences.


right now i have:

=SUM(IF(CLOSED!$G$3:$G$1500>=$G$1,IF(CLOSED!$G$3:$G$1500<=$H$1,IF(OR(CLOSED!K3:K1500="MS",CLOSED!K3:K1500="IRA"),CLOSED!N3:N1500,0))))

Obviously if you know the correct syntax - you'll realize this is
incorrect and providing the wrong answer.

I want it to sum closed!n3:n1500 cells that have their range g3:g1500

=g1 and <=h1, and also have EITHER MS or IRA in the column K.

Thanks
sg

 

[Bob Phillips]

Did you enter it as an array formula (Ctrl-Shift-Enter)?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)