sumif with 2 criteria
Trying to do a formula as follows:
Sheet1 Sheet2 Account # Monthly YTD Account # Code YTD 510000 5,000.00 15,000.00 510000 Expense $50,000.00 Formula not working: =SUM(IF(((B4='Account Type'!C291)*(Input!B291="A")),Input!H291,"")) So, if Sheet1 Account # = Sheet2 Account # and Sheet2 Code = Expense, then give me the sum of Sheet1 YTD This seems simple, but I am getting hung up somewhere. Please help! |
sumif with 2 criteria
why do you need SUM when there is only one field. Use
=IF(AND(B4='Account Type'!C291,Input!B291="A"),Input!H291,"") -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "sumif and" <sumif wrote in message ... Trying to do a formula as follows: Sheet1 Sheet2 Account # Monthly YTD Account # Code YTD 510000 5,000.00 15,000.00 510000 Expense $50,000.00 Formula not working: =SUM(IF(((B4='Account Type'!C291)*(Input!B291="A")),Input!H291,"")) So, if Sheet1 Account # = Sheet2 Account # and Sheet2 Code = Expense, then give me the sum of Sheet1 YTD This seems simple, but I am getting hung up somewhere. Please help! |
sumif with 2 criteria
Well....it is a bit more complicated that this, because on Sheet1 I may have
multiple rows in which it finds 510000, so I am going to have to sum all hits of that account. I'll try it..... "Bob Phillips" wrote: why do you need SUM when there is only one field. Use =IF(AND(B4='Account Type'!C291,Input!B291="A"),Input!H291,"") -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "sumif and" <sumif wrote in message ... Trying to do a formula as follows: Sheet1 Sheet2 Account # Monthly YTD Account # Code YTD 510000 5,000.00 15,000.00 510000 Expense $50,000.00 Formula not working: =SUM(IF(((B4='Account Type'!C291)*(Input!B291="A")),Input!H291,"")) So, if Sheet1 Account # = Sheet2 Account # and Sheet2 Code = Expense, then give me the sum of Sheet1 YTD This seems simple, but I am getting hung up somewhere. Please help! |
sumif with 2 criteria
Which is Sheet1, the one with B4, 'Account Type', or 'Input'? If you have 510000 in one test you must have 510000 in the others. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "sumif and" wrote in message ... Well....it is a bit more complicated that this, because on Sheet1 I may have multiple rows in which it finds 510000, so I am going to have to sum all hits of that account. I'll try it..... "Bob Phillips" wrote: why do you need SUM when there is only one field. Use =IF(AND(B4='Account Type'!C291,Input!B291="A"),Input!H291,"") -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "sumif and" <sumif wrote in message ... Trying to do a formula as follows: Sheet1 Sheet2 Account # Monthly YTD Account # Code YTD 510000 5,000.00 15,000.00 510000 Expense $50,000.00 Formula not working: =SUM(IF(((B4='Account Type'!C291)*(Input!B291="A")),Input!H291,"")) So, if Sheet1 Account # = Sheet2 Account # and Sheet2 Code = Expense, then give me the sum of Sheet1 YTD This seems simple, but I am getting hung up somewhere. Please help! |
All times are GMT +1. The time now is 06:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com