Trimmean function

[jsical]

I have the following Data: Amount |Date | Spread for a large set of data. I know how to use TRIMMEAN but i am not sure how to incorporate multiple conditions. i.e I would like to use trimmean to looked at Amounts >=100 &<=500, and Dates >= 01/01/2021 &<=12/31/21, and return the mean Spread base on the data that falls between the 2 criteria of Amount and Date. i am not sure what the syntax would look like. I can do this for an specific set of data but not for in between two sets of data =TRIMMEAN(IF((Amount=50)*(date =12/01/31),Spread),10%) . any help would be greatly appreciated.

 

[jasonb75]

I had thought that earlier, but dismissed it as the cause because I was seeing a #VALUE! error instead

Glad you got it working.

 

[jsical]

Thank you! I used to be better at this but I haven’t had the need to use excel until now. Syntax has changed a bit from wha I used to know. Once again thank you for your help.