Formula Help

[Wilcock1]

Hi

Please can you assist with the following problem that I have. I am trying to bring back a value based on three scenarios.

The current formula I have is quite simple SUMIF($AZ3,BE$2,$BW3) but I would now like to add to this for two further scenarios. I think it would be something like =SUMIFS($AZ3,BE$2,$BW3), ($BB3,BE$2,$CA3),($BD3,BE$2,$CE3) but I know that I havent got the structure right. I'm not sure if this is enough information to assist but I hope so.

Thank you in advance for your help!

Andrew

 

[etaf]

SUMIFS($AZ3,BE$2,$BW3), ($BB3,BE$2,$CA3),($BD3,BE$2,$CE3)

the SUMIFS structure is [FONT=&quot]SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)[/FONT]

I dont understand your sum range, criteria range or criteria