Getting tired of typing out the full word and want to make sure the full word is spelled the same every time.
On sheet 1 (Bills) I have
A____B
Code Description
B01 Rent
B02 Power
B03 Cable
on Sheets 2-13 (Paid, Jan - Dec) I have
A____C
Code Description
I tried on sheet Jan =IF(ISBLANK(A3),"",SUMIF(Bills!A2:A27,"="&Jan!A3,Bills!B2:B26))
but it comes back with 0 instead of Rent, Power, Cable why???
A bit of a guess, since you didn't attach an Excel sheet; but is this close?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
OK thanks Glenn so I us match instead of sum thanks looks good
Glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.
=IF(ISBLANK(A3),"",SUMIF(Bills!$A$2:$A$27,$A3,Bills!$B$2:$B$26))
On sheet 1 (Bills) I have
A____B
Code Description
B01 Rent
B02 Power
B03 Cable
there is no numbers in either columns, how you will get result, attach sample excel file
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
When I transferred it into my book I had to make a small change
had to change the = after IF(A2="," to IF(A2<>"," and it works perfect thanks again glenn
this is the final formula I end up using
=IF(ISBLANK(A2),"",IF(A2<>",",INDEX(Bills!$B$2:$B$26,MATCH('Jan01'!$A2,Bills!$A$2:$A$26,0))))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks