sumif Multiple critera Help required

[scottmac]

hello I want to do the following some how

Sumif( Colum B & Colum E, are between 0 and 30 and facility of loan >500 the sum range colum is ColumG)


Any ideas


thanks

 

[ChrisR]

Hi,

Have a look at =SUMIFS

It's a multiple criteria SUMIF

Regards,
Chris