Hi,
I have a problem with Subtotal and a IF formula, when I type a formula which should say Under- or over budget and the Monthly budget is displaying above my calculation the formula will move down four steps because the subtotal function only display the total. I can't get it to work.
Sorry for my bad description, I hope this image will show it better.
excel.jpg
G'day,
Does this help ?
Click here
Cheers
Have I made you happy ??? If yes, please make me happy by pressing theAdd Reputation button in my post.
Please don't forget to do the same to other contributors of this forum.
ThanksI don't void confusion, I create it
Hi ratcat,
Thanks for you answer, that seems a little bit to complicated, do you think that's the only way to go?
Well its the only way with the bold thingy I know of.
A suggestion is that you go with a sumif formula. Based on your jpeg layout. I'll use the 'Description' column. If there is a "Y" in the Description column it will sum the amount in D col
=SUMIF(C15:C32,"Y",D15:D32)
Hmmmm second thoughts are you a where of the Subtotal.
One of the formula functions that will calculate visible rows, but disregard the bold or not bold
=SUBTOTAL(109,D15:D32)
Subtotal Table
http://www.excelforum.com/1976712-post2.html
HTH
Try this formula
=IF(AND(LEFT(A11,5)<>"Grand",ISNUMBER(SEARCH("total",A11))),IF(D11>INDEX($A$2:$A$8,MATCH(SUBSTITUTE(A11," Total",""),$B$2:$B$8,0)),"Over budget","Under budget"),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks