|
Sum Product Function Maybe
I need to add another condition to my formula. =$B15-(SUMIF($I$53:$I$533,$C15,$H$53:$H$533)) The formula I'm using is works now I need each line to look at Column F and If it equals F15 then do the formula and conditions below. Each row needs to look at $F53:$F533 to see if it = F15 Each row needs to look at $I53:$I533 to see if it = C15 B15 - (sum( of the true amounts in $H53:$h533 Any help will be appreciate my boss wants this change this afternoon if possible. Please make me look good. -- lostinformulas ------------------------------------------------------------------------ lostinformulas's Profile: http://www.excelforum.com/member.php...o&userid=35229 View this thread: http://www.excelforum.com/showthread...hreadid=555740 |
Sum Product Function Maybe
Hey lost
This should work for you =B15-(SUMPRODUCT(--(F53:F533=F15),--(I53:I533=C15),H53:H533)) confirm with cntrl+shft+enter Let me know if this works for you. Dave "lostinformulas" <lostinformulas.2a0xvz_1151350206.1051@excelforu m-nospam.com wrote in message news:lostinformulas.2a0xvz_1151350206.1051@excelfo rum-nospam.com... I need to add another condition to my formula. =$B15-(SUMIF($I$53:$I$533,$C15,$H$53:$H$533)) The formula I'm using is works now I need each line to look at Column F and If it equals F15 then do the formula and conditions below. Each row needs to look at $F53:$F533 to see if it = F15 Each row needs to look at $I53:$I533 to see if it = C15 B15 - (sum( of the true amounts in $H53:$h533 Any help will be appreciate my boss wants this change this afternoon if possible. Please make me look good. -- lostinformulas ------------------------------------------------------------------------ lostinformulas's Profile: http://www.excelforum.com/member.php...o&userid=35229 View this thread: http://www.excelforum.com/showthread...hreadid=555740 |
Sum Product Function Maybe
lostinformulas wrote:
I need to add another condition to my formula. =$B15-(SUMIF($I$53:$I$533,$C15,$H$53:$H$533)) The formula I'm using is works now I need each line to look at Column F and If it equals F15 then do the formula and conditions below. Each row needs to look at $F53:$F533 to see if it = F15 Each row needs to look at $I53:$I533 to see if it = C15 B15 - (sum( of the true amounts in $H53:$h533 Any help will be appreciate my boss wants this change this afternoon if possible. Please make me look good. Try this: =$B15-(SUMPRODUCT(($I$53:$I$533=$C15)*($F$53:$F$533=$F15 )*($H$53:$H$533)) -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
Sum Product Function Maybe
Ctrl-Shift-Enter is not necessary.
-- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Dave" wrote in message ... Hey lost This should work for you =B15-(SUMPRODUCT(--(F53:F533=F15),--(I53:I533=C15),H53:H533)) confirm with cntrl+shft+enter Let me know if this works for you. Dave "lostinformulas" <lostinformulas.2a0xvz_1151350206.1051@excelforu m-nospam.com wrote in message news:lostinformulas.2a0xvz_1151350206.1051@excelfo rum-nospam.com... I need to add another condition to my formula. =$B15-(SUMIF($I$53:$I$533,$C15,$H$53:$H$533)) The formula I'm using is works now I need each line to look at Column F and If it equals F15 then do the formula and conditions below. Each row needs to look at $F53:$F533 to see if it = F15 Each row needs to look at $I53:$I533 to see if it = C15 B15 - (sum( of the true amounts in $H53:$h533 Any help will be appreciate my boss wants this change this afternoon if possible. Please make me look good. -- lostinformulas ------------------------------------------------------------------------ lostinformulas's Profile: http://www.excelforum.com/member.php...o&userid=35229 View this thread: http://www.excelforum.com/showthread...hreadid=555740 |
Sum Product Function Maybe
Thanks Everyone both formula's work. and I was quite sure what to do with the Crtl Shift Enter. So that hint was helpful also. You guys maded me look like I know what I'm doing!!! thanks again. -- lostinformulas ------------------------------------------------------------------------ lostinformulas's Profile: http://www.excelforum.com/member.php...o&userid=35229 View this thread: http://www.excelforum.com/showthread...hreadid=555740 |
Sum Product Function Maybe
Bob
I thought it was necessary for the logical operation, I mean the comparison of each cell in the range to F15 and C15. Obviously I'm wrong. Thanks for saving me the key strokes. Dave "Bob Phillips" wrote in message ... Ctrl-Shift-Enter is not necessary. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Dave" wrote in message ... Hey lost This should work for you =B15-(SUMPRODUCT(--(F53:F533=F15),--(I53:I533=C15),H53:H533)) confirm with cntrl+shft+enter Let me know if this works for you. Dave "lostinformulas" <lostinformulas.2a0xvz_1151350206.1051@excelforu m-nospam.com wrote in message news:lostinformulas.2a0xvz_1151350206.1051@excelfo rum-nospam.com... I need to add another condition to my formula. =$B15-(SUMIF($I$53:$I$533,$C15,$H$53:$H$533)) The formula I'm using is works now I need each line to look at Column F and If it equals F15 then do the formula and conditions below. Each row needs to look at $F53:$F533 to see if it = F15 Each row needs to look at $I53:$I533 to see if it = C15 B15 - (sum( of the true amounts in $H53:$h533 Any help will be appreciate my boss wants this change this afternoon if possible. Please make me look good. -- lostinformulas ------------------------------------------------------------------------ lostinformulas's Profile: http://www.excelforum.com/member.php...o&userid=35229 View this thread: http://www.excelforum.com/showthread...hreadid=555740 |
Sum Product Function Maybe
Dave,
SUMPRODUCT is an array function so it doesn't need to be array entered, Excel already knows. It only needs array entering if there is some other nested function within that is not capable of processing arrays directly, and that needs to be array entered. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Dave" wrote in message ... Bob I thought it was necessary for the logical operation, I mean the comparison of each cell in the range to F15 and C15. Obviously I'm wrong. Thanks for saving me the key strokes. Dave "Bob Phillips" wrote in message ... Ctrl-Shift-Enter is not necessary. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Dave" wrote in message ... Hey lost This should work for you =B15-(SUMPRODUCT(--(F53:F533=F15),--(I53:I533=C15),H53:H533)) confirm with cntrl+shft+enter Let me know if this works for you. Dave "lostinformulas" <lostinformulas.2a0xvz_1151350206.1051@excelforu m-nospam.com wrote in message news:lostinformulas.2a0xvz_1151350206.1051@excelfo rum-nospam.com... I need to add another condition to my formula. =$B15-(SUMIF($I$53:$I$533,$C15,$H$53:$H$533)) The formula I'm using is works now I need each line to look at Column F and If it equals F15 then do the formula and conditions below. Each row needs to look at $F53:$F533 to see if it = F15 Each row needs to look at $I53:$I533 to see if it = C15 B15 - (sum( of the true amounts in $H53:$h533 Any help will be appreciate my boss wants this change this afternoon if possible. Please make me look good. -- lostinformulas ------------------------------------------------------------------------ lostinformulas's Profile: http://www.excelforum.com/member.php...o&userid=35229 View this thread: http://www.excelforum.com/showthread...hreadid=555740 |
| All times are GMT +1. The time now is 01:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com