#NAME? Problem With SUMIFS Formula

[meppwc]

The formula below returns "#NAME?" and I don't know why. I suspect the reason may be because there are columns used in the equation that are formula cells.
But if this is the reason, how do I get around it
Basically the formula is trying to achieve a sum of column O if two conditions are met
Column O is populated with numbers (represents dollar amounts)
Column AD is populated with numbers (account numbers)
Column AA values are numeric but the real contents of the cell is a formula (=MID(C3,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},C3&"0123456789")),99)*1)
Column BB values are numeric but the real contents of the cell is a formula (=MONTH(D3))

=SUMIFS(O:O,AA:AA,AD3,AB,"1")

 

[jorismoerings]

Hi,

The Criteria_range(s) argument must contain the same number of rows and columns as the Sum_range argument.
=SUMIFS(O:O,AA:AA,AD3,AB,"1")

Just AB is doing nothing, if it's a namend range, check the number of columns and rows with your named range.

 

[meppwc]

OMG............I cannot believe that I missed that......if should read AB:AB
Thanks for the assistance.