Recent content by farrusete

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