Search results

Hi, Maybe this is more a math question than an excel one so sorry in advance if this is an offtopic but id appreciate if someone could help me on this. I have several tests delivered to a group of users and id like to have a column to have some kind of "success rate" related to the test itself...

I was trying to put the conditional in the wrong position... this worked for me: =SUMPRODUCT((Table[Column1]=A9)*(IF($B$2<>"ALL",Table[Column2]=$B$2,Table[Column2]<>"ALL"))*Table[[costs january]:[costs december]])

Hi, How could I do something like this? (between ----> and <----): =SUMPRODUCT((Table[Column1]=A9)*(Table[Column2]=---->IF($B$2<>"ALL",$B$2,"<>ALL")<----)*Table[[costs january]:[costs december]]) I mean, to set a conditional returning a dynamic value for that column. If value in B2 is "ALL"...

Thank you again Somendra!

Hi Somendra, The point is to sum all revenue lines. In the xls it would be to sum 3 revenue lines for USA until october but it has to be dynamic. If i enter month number 3 and select "Cost" and "EU" it should sum all cost llines from EU (2 lines) from january to march. Thanks again

hmmmmm im trying to figure out if there is a way to use SUMIFS instead of SUM to get just values with certain conditions (edited excel attached). Thanks again

Thank you so much :)

Hi, Im trying to sum values from a row until column named with the limit date (month in current year) manually entered in a cell. Maybe attached file is clearer than me... sorry Thank you in advance,

Thank you Chihiro!

Hi, Is there a way to access a table column range from a given cell value? Lets say that table1 is named "People" and one column header is "ene-15". I would be able to access that column range with "=People[ene-15]". How could I set a formula to access dynamically to that column based on other...

You are right. I copied/pasted columns and didnt remove previous values. It works great for finding last invoiced month (i hace to check it in order to know how it works). Any clue about my second question? Thank you again

Hi, Im trying to locate last column with value from non adjacent columns and set that one's column name in a cell. Please check attachment because this is a bit tricky. Column in red for line 1 should say "jan-15" and it should be empty for line 2. It should be the last month in which we have...

Great! Thank you so much uke M

Hi, Im trying to sum columns from a table based on values in different cells. Something like =SUM(Table1["Invoicing "&B16&"-"&C15]) Is this possible? (excel attached) Thank you in advance

Thank you so much Luke!

Hi, I have one table with different columns: Col1, Col2, Col3 -> Values Selector -> Contains duplicated values which will be used for dropdown in Test sheet Auto1, Auto2, Auto3 -> Calculated cells to be shown in pivot table at Calculations Sheet When I select a value from the dropdown at test...

Resolved It by following answer on post http://forum.chandoo.org/threads/help-with-date-formulas-with-a-twist-of-days-between-start-end-date.16516/#post-100038 Just attaching file for other users with the same question. Regards,

Hi all, Just wondering if there would be an optimized way to calculate days between two dates and just taking those in a given month. For instance, id need to get from 05/01/2014 to 07/15/2014 the numbers of days in june 2014 (these would be 30). Also, from 06/15/2014 to 12/31/2014 would be...

Hi, Im starting with PowerPivot and just moving previous reports to practice. I have a date column which includes both dates (dd/mm/yyyy hh:mm:ss format or just "unlimited" text). I created a calculated field with =IFERROR(DATE(MID([end date], 7,4),MID([end date], 4,2),LEFT([end date]...

Thank you so much!

Hi, Im trying to get data from a different sheet table by matching IDs but im in troubles with values containing "~" character. For those the formula returns "#N/A" =INDEX(Keywords[Description];MATCH([@Keyword];Keywords[Keyword];0)) How would you manage to get this working? (Id like to avoid...

Thank you so mucho Narayan. It works! Ill check those formulas to learn the way you did it

No worries. im the one not being that clear :) You can find attached what im trying to explain. If I use top10 filter, dashboard will be filled in that "manual way" (top.xlsx) but imagine that at the begining of february region2 has less than 10 advertisers (top2.xlsx). Then i will have to...

Thank you too AIM but im trying to find a less manual solution in order to get my dashboard tab updated automatically and not to have to point to cells manually every day Again thank you for your reply

Hi bobhc Thank you for your quick answer! Sure it woud work but my data sheet will contain regions with less than 10 advertisers and i would like not to point data directly from pivot sheet (like "=pivot!A5" for top advertiser1 in region1 and...