adding figures that match 2 true and 1 false if statement cond Eduardo, if only I could get a course I would understand some of your code :) but I have been able to amend it to meet my needs so your are brill :) many thanks UKMAN "Eduardo" wrote: Hi, As this is a consolidation I assume you have in column A name (sid in A2), in column B car in B2, in colum... 24 Mar 2010 14:43 adding result of "if" statement.. I have created this "if" statement. =IF(G17=(166719),"1", IF(G17=(165852),"2", IF(G17=(165851),"0", IF(G17=(166718),"1", IF(G17=(166685),"4", IF(G17=(166745),"0", IF(G17=(""),"" ))))))) Now i want to add the result of this statement from consecutive rows. i did sum on the results but i am not able to add the... 25 Mar 2010 16:16 SELECT SUM(h) WHERE e = 'eBay Payment Sent' If SQL queries could be performed in Excel, I'd do "SELECT SUM(h) WHERE e = 'eBay Payment Sent'". Since SQL doesn't support SQL, however, I need to try something else. The following didn't work: =SUMIF(E2:E542,"=eBay Payment Sent",H2:H542) Any ideas what will work? Thanks! ... 24 Mar 2010 15:53 Date Formatting With the help of Biff yesterday I entered the formula ="Closing Balance at "&TEXT(E4,"dd-mmm-yyyy") which returned Closing Balance at 31-Mar-2010 exactly as I wanted - almost. My superiors require that to conform with the rest of the document the month element of the date be in upper case, i.e. Closing Balance... 24 Mar 2010 14:43 adding figures that match 2 true and 1 false if statement conditio As ever many thanks in advance for any help. I am struggling to understand how I can say not equal in an if statement in excel:( I need to consildate a table which layout is basically: Col A Col b Col c Col d Col e (name Car basic Bonus status) sid 50 100 10... 24 Mar 2010 13:32 Excel not pasting the formula or reference I am trying to take a worksheet "apple" and copy it to a new workbook "banana". It works for another worksheet but not this one. I am highlighting the whole worksheet and copying it and then opening the workbook sheet and clicking the corner box and selecting paste. When it works correctly the cell would look li... 24 Mar 2010 14:43 Too many rows highlighted When I click on a row, multiple rows are automatically selected. This happens to all of my sheets in my workbook. Do I have a bug? How do I fix this? ... 24 Mar 2010 13:32 Sumproduct? Good Afternoon Please could someone help.... I have a monster spreadsheet that tracks recruitment numbers and as part of our monthly reporting i need to count various monthly stats The information i need to summarise for each department is: the number of internal candidates that were offered in each month... 24 Mar 2010 13:32 Complicated IF statement - desperately need some help Afternoon everyone. Have been struggling to get a formula together for the following. I am being told due to its complexity that I will probably need to break it down into 2 sections but hoping someone can help me simplify things. I need to do the following A1 = 1 (although this can be 1,2,3,4,5) (This is ... 25 Mar 2010 18:37 HELP! How can i combine two formulars together? =COUNTIF(L9:L453,"Deal*") =COUNTIF(A9:A452,"15/03/2010") Im trying to find out how many DEALS on a certain date ... 25 Mar 2010 05:46