sum product if

  1. D

    Calculate weighted averages from a subset of data.

    Hi all, I have a subset example of my data below to help with this question. <tbody> A B C 1 Seam TK*RD ASH 2 A 2 5 3 A 1.8 6 4 A 2 5 5 B 3 10 </tbody> What I need to be able to do is calculate the weighted average 'ASH' value when the 'SEAM' column equals "A". To do this for...
    • dunlop407703
    • Thread
    • sum product sum product if sumproduct sumproduct if weighted average
    • Replies: 24
    • Forum: Excel Questions
  2. F

    =COUNTIFS - the name matches one of the names in a range

    I need my COUNTIFS formula to only count if one of the people who appears in column F is also one of the people in a range on another tab here: =Key!V2:V12. So in this formula below, A_List_Import!$F:$F,'All Dates'!$A$501 is just looking for one person. But I need it to count it if the person...
  3. S

    Diagonal Sum Product If Formula

    I am stumped on coming up with a dynamic formula that calculates a value based on an increasing number of "sums of products". Specifically, I need to calculate the total number of repeat users based on a "decaying' repeat rate. In other words, I need it to calculate = Sum[...

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