View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sumif and sumif and is offline
external usenet poster
 
Posts: 1
Default 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!