Search results

i'd like to keep cell A10 constant. so Untill i populate the above rows with data, cells A11, B11 and C11 stay at 0, once i start to populate the rows with THX data and other models, i expect the 0's to change to figures. if that makes sense? from A9 to O11, im going to make a copy of this for...

hi brian, i tried that formula with the <> but i still get the error when i change THX in cell B2 to some other value. Shades, thanks for the suggestion; i still get the problem when i put in (<=). when THX is in cell 2, it comes back as 0 using (<=), even if i put in banannas in cell B2 it...

thanks brian for taking out your time to look at this sumproduct formula

hi brian, i tried that, but when i put =0, it the values come back as 0's. i have attached a example worksheet to show you what i mean,

brian, i've edited the formula and tried to use a IF statement instead, it partially works but im falling down at the <0,0, bit. i'd like it display a zero if the value by the first bit of calculation amounts to 0. but it doesnt seem to do this

hi, im trying to wrap my formula around the IS Error function: =SUMPRODUCT(($J$174:$J$274)*($C$174:$C$274=$B$406)*($F$174:$F$274>=$C$393*($F$174:$F$274<=$D$393))/SUMPRODUCT((1)*($C$174:$C$274=$B$400)*($F$174:$F$274>=$C$393)*($F$174:$F$274<=$D$394))) thats the original formula, now with is...

ok i have changed course with this to make it a little bit more simple. i have used SUMIF and COUNTIF functions as it shortens the formula down. i am looking In cell D21, i have tried to joing the CountIF and SumIF formulas together with the 2 vlookups, but i cant get it to work. what i...

hi, this is a progression from a previous thread with a thankyou to Helicopter's help:) EDIT: see 2nd post below. thanks

hi helicopter, i am basically making quarterly pricing lists. i have attached a sample of what i would like to do: i have 3 entries of data. i want to make a list of the panasonic data for Quarter 4 in 2007 for all panasonic items. basically i want to copy the panasonic entries from the above...

hi, i would like to streamline the way my IF formula works. at the moment it is: =IF(AND($C500="Panasonic",AND($F500>=39356,$F500<=39447)),$J500,0) it looks at rows of data, if for instance the date the entry was added was in december 07, it would be flagged by the serial dates in the...

helicopter, im going to put this formula on hold for the short term, something else has come up, (new post)

hi, i have a IF formula. =IF(AND($C175="product A",AND($F175>=39448,$F175<=39532)),$J175,0) were i have highlighted in red, rather than it looking directly at the cell reference in question as it is now. i'd like it to look at 2 cells: i.e. cell A would have the letter C in it and cell B2...

tar chaps, got it to work with a OR addtion :D :D =IF(OR(ISTEXT(D88),D88=0),"-","") took some time trying to find out where to stick the OR text but finally got there.

thanks guys :) it works a treat, i saw the Istext in excel help files but it only outputted a 'True' or 'false' option. next question is, sometimes cell D88 can have a '0' value in it, how can i get the Istext formula to dissmiss it into thinking the cell is empty? regards rvd48

sorry helicopter, im some what of a noob with vb code :o yes, the a) Non Standard Sign Offs is a valid folder with all the individual files such as AA123. where do i put this code? in the vb code bit of the 'workbook'? cheers, rvd

hi, im trying to solve my if statement: =IF(D88>1,"-","") i want it to do this: if there is any text in cell D88, then show a dash (-) otherwise display nothing. i need to get rid of the >1 , but i dont know what to replace it with that signifies as text. any help please?

hi, i have a excel sheet where i keep a log of some information in each row. Per row, there is a unique reference, e.g. J:\a) Non Standard\A123.xls. this represents an excel document in another folder. Now, i would like this reference column to be live, so that when i click on the reference of...

hi, my formula is working fine apart from 1 little problem. when my list of figures becomes small, such as 0.042, then the averages formula ignores it. =IF(SUM(AH29:AH58)=0,0,SUMPRODUCT((AH29:AH58>0)*AH29:AH58)/SUMPRODUCT(--(AH29:AH58>0))) now, this =0 bit i think is the problem. it does...

i get the just of the formula, but find it hard to change it as it looks fairly complicated now.

ok, my IF formula as it stands is: =IF(AND($C57="2105",AND($F57>=39234,$F57<=39325)),$J57,0) it says if the item is 2105 and the date is between 39234 and 39325, then displays whats in cell J57 otherwise return a 0. now, i want another condition, i want it to also check if it says mp 110 as...