# subproduct

1. ### Finding Header and Row name based on Value

I have a table of 1000 students (names in Column A) and roughly 100 courses (in Row 1) and a list of IDs for the students unique to their respective course. I am given an ID for a student and I need to access the students name and the respective course. For instance, I may receive H19 and I...
2. ### Subtotal Ifs

I have tried the multiple solutions on this forum and can not get it to work. Use-Case: I want to sum a total amount of cells on the IF statement that they are considered a "Renewal" and that they are within the dates of 2/1-2/28/2012. So 2 if clauses, or 3 if I have to specify the 2/1/2012...
3. ### SUMPRODUCT to count BETWEEN numbers and only VISIBLE cells

Hello, Im currently using this formula to count cells that match the contents of another cell. It works perfectly only counting visible cells. =SUMPRODUCT(--(\$A\$12:\$A\$50000=A50003),(SUBTOTAL(103,OFFSET(\$A\$12,ROW(\$A\$12:\$A\$50000)-MIN(ROW(\$A\$12:\$A\$50000)),,)))) I need another formula to count...

### 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.

### Which adblocker are you using?

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

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