excel formulas

My spreadsheet has a list of customers and invoice amounts and a yes or no that indicates whether or not they have paid. I want to sum only the amounts that have been marked as a yes (for paid.) I tried using the sumif function but it didn't work correctly. My next idea was to do an imbedded...

I am trying to have a value from sheet1 'Site Visit ASESSMENT for a specific cell to appear on another sheet (let's call it sheet 2) only if if certain statements exists in another cell such as E3 in sheet 1 Statemetns are PARTIAL COMPLIANCE,NOT COMPLIANT,NOT ASSESED,ADDITIONAL INFO NEEDED...

All, I have a file that catalogs fire alarm devices in multiple buildings by and ID number( in one column) and status ((either incomplete, complete, etc.) in another column). Each building has its own tab that is formatted just like the rest. I am trying to make a cover page for this file that...

I am working on a tool/worksheet that grabs the data from a user-inputted sheet (Sheet 1). The data the user inputs can vary in length, i.e. # rows. The last cell entered by the user is transferred to the first cell in another worksheet (Sheet 2). I want to basically flip the data from how the...