Sumifs

[Spoon2322]

Hi All,

I trying to work out the formula that would populate a cell with a budgeted amount based on 2 criteria - please can anyone assist? I have attached workbook that has actuals and budget and it is cell AU 4 and5 I need to populate. For ease I have put the budget on same sheet.

Thank you in advance

suzanne

PS How do I post attachments!

 

[joeu2004]

Yeah, I would need to see the Excel file. We cannot attach files in this forum. Upload the Excel file (redacted) to a file-sharing website (e.g. box.net/files) and post the public/share URL in a response here. Test the download URL, being careful to log out of the file-sharing website first. (If you use box.net/files, ignore any preview error, and just download.)

Some participants object because they cannot or will not download files. If your example is simple enough, perhaps you can post the data and formulas, complete with cell names, here.