ages

  1. T

    Average Age using decimals

    Hi I have been given a sheet of ages and asked to calculate the average. However the ages are in decimals e.g. 10.04 = 10 years and 4 months, 11.11 = 11 years and 11 months. Any ideas how to calculate an accurate average in excel?
  2. P

    Countifs

    Just need some help with an additional ask. I have the following formulae, which provides aged analysis on all of my data. There are further ages (this is a sample) SUM(COUNTIFS(DataWIP!$H:$H,{"A- High","B - Associate - Hi"},DataWIP!$AL:$AL,"WIP",DataWIP!AN:AN,"<="&0))...
  3. K

    how to fill cell m34-dh34 with certain condition?? (vba)

    note: Time: Cell D6 Date Format Birthday: Month, Date, Year cell D3-f3 Age / Age: cell m 15 - dh15 Cell M34 - DH34: Place in its contents PINNACLE VALUE according to Time value Pinnacle Value: the result of addition of D3-F3 cell , THERE IS of 4 Pinnacle value . Iam looking for formula or vba...
  4. B

    Need to know formula to sum up 3 largest rates depending on age factor

    Hello, I am making rate calculator for clients to type in their ages and the ages of their dependents to know their insurance premium. Blue Cross has the rule that subscribers only pay for the first three dependents under the age of 21. (the largest 3). These ages and rates are only a sample...
  5. B

    Index with 3 Matches

    Hi - Could someone kindly help me work out the below (a little stuck with it); =INDEX(Sheet1!AG2:AK36,MATCH(A10,Sheet1!A2:A421,0),MATCH(A1,Sheet1!AF2:AF421,0),MATCH(B9,Sheet1!AG1:AK1,0)) Been messing around with it for ages and just can't get it to work. Thanks in advance!

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