Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with adding to a formula
Hi,
I'm using the following formula to add the totals in cell O10:O32 if the data (which is a 4 digit code) entered in cell P12 matches any of the the codes entered in cells A10:A32. If no match..then the answer is blank...or if no total is in O12 then the answer is blank. =IF(O12="","",(SUMIF($A$10:$A$32,P12,$O$10:$O$32)) ) For Example: Col A Col O Col P Col Q (Codes) (totals) (Summary of Codes from A) (This col with the formula in it..and answers a) 1234 1000.00 1234 1000.00 1235 2000.00 1235 5000.00 1235 3000.00 3200 500.00 3200 500.00 This is working great! Here's where I need help: I've added a new column that I need to factor into the formula and I'm not sure how to do it.. The column is B ....which could have an X entered by the codes in A or not. If there is an X entered in column B -- then.... I need the formula to look at P12 to see what the code is...and see if there are any matching ones in Cells A10:A32.. if it finds matching codes..then it needs to look at cells B10:B32 and if any of the matching codes have an X next to them...then the formula will not include that code's total in it's calculation...... see below: Col A Col B Col O Col P Col Q (Codes) (exclude) (totals) (Summary of Codes from A) (This col has the formula in it..and answers a) 1234 1000.00 1234 1000.00 1235 x 2000.00 1235 3000.00 1235 3000.00 3200 500.00 3200 500.00 There are two entries for code 1235 in col A..but one has an X in col B next to it..so the total in Col Q for the code listed in Col P...doesn't included that total of 2000.00 for code 1235. Any help to accomplish this would be greatly apprecaited! Thanks in advance Kimberly |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding formula | Excel Worksheet Functions | |||
Adding to formula | Excel Discussion (Misc queries) | |||
adding a formula | Excel Discussion (Misc queries) | |||
adding a formula including the value another formula gets | Excel Discussion (Misc queries) | |||
Adding another formula to and Exsiting Formula | Excel Programming |