SUMIF and LEFT and Named Ranges

D

DaveMoore

I have two named ranges in a table, 'AccNo' and 'AugustP'. Both
ranges are equal in length and occupy the same rows. 'AccNo' may have
the same value in more than one cell in the range.
My formula, =-SUMIF(AccNo,$B6,AugustP) works well where cell B6 equals
a cell in the named range 'AccNo', typically the number 5000.
I want to change the value of those cells in 'AccNo' with a text value
of say 5000-01, keep the value in B6 and still retain the value
produced by the original formula.
I have tried the formula =-SUMIF(LEFT(AccNo,4),$B6,AugustP) but Excel
tells me there is an error in the formula. I have made sure the cells
in 'AccNo' and B6 are formatted as text.
Has anybody any suggestions?
Thanks for any help offered,
Dave Moore
 
B

Bob Phillips

we heard you the first and the second time.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top