sumsifs

  1. N

    SUMIFS criteria with blanks

    Hello, I try to calculate total amounts with SUMIFS. Sheet Products contains name of products, category of products, release and end date of products and amount information on rows. Sheet Amounts is used to calculate total amounts based on categories. I have couple different criteria and one...
  2. S

    Add all scores that relate to an applicant number then rank

    I am creating a form to rank grant applications. I need to total all the points from various judges for each applicant, then rank them. This is an example of the data from sheet one: 09.27.2016-13.47.30 - GRogne1's library And this is sheet two: 09.27.2016-13.46.43 - GRogne1's library What...
  3. T

    SUMIFS to include only blank field for one of the criteria

    I am looking to utilize the SUMIFS formula for my time tracking spreadsheet. I have one criteria to sum values that are equal to a certain value "V" for vacation, and "D" for Dr Appointment. I am not trying to include the criteria that sums those values if they haven't been submitted, so I can...
  4. B

    problem- copying formula to other cells works fine bar 4 cells which return #VALUE!- help?

    as the title suggests, I'm having a problem with copying a formula across multiple cells. Copying has worked fine on most of the cells however not for 4 cells which instead get #value! returned. It also says that data entered is of the wrong type. I have checked and re-checked my data and...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top