Search results

Thank you so much for all the responses...trying them out now.

Hi Prasad, thanks, but it does not work. I need to add that I cannot change the structure of the file. To the right I've added examples...any of the criteria can change (no. of weeks, comp, type) and other than manually adding it up I'm not sure how to do it.

Hi, I need to sum rows based on criteria on both columns and rows. How do I do that? For example, I want the sum of sales for stores that are of type "SIS" and are comp "Y" for weeks 1-4. See attached example file. Thank you.

Wow, learned something new. Thanks Luke M and SirJB7.

Thanks Faseeh...vlookup works so much better than an IF statement. Much appreciated.

Hi, how do I look up values in a table, and based on the value, use a certain formula? For example, a student gets a refund based on how long they were in school before dropping...less than 3 days, 95% refund, 4-7 days(1 week), 90% refund,a quarter into the academic year, 75% refund, halfway...

Hi, I have the year end percentages but there was an increase during the year. So say I started at 60% in Jan but increased to 65% in May for the rest of the year. At year end I would be at 65%. I have the year end number and the amount of increase during the year and when it happened...how...

Hi, is it possible to use the Match and index formulas to match three values? For example, right now I'm matching the account and year to pull in the value I need. I need to add a third dimension...match the department, account and year to pull in the value. How can I do that? Help! Thanks.

Thanks Hui...this was very helpful.

Hi, is there a way to use conditional formatting to do neat things like have a cell flash when certain criteria are met? For example, if the result of a formula is not equal to zero, hightlight the cell, flash,blinking lights, etc. to draw attention to the delta. Thanks.