Excel Formulas help Please !

[mita parmar]

Hi Chandoo,
Hope you are well.
I was wondering if you could help with a formula I need.
Basically, I need to write “simple” code which finds criteria 1, and then looks to find criteria b from the value ranges to give me the resulting factor value
Hope I have explained myself correctly and that you can help

 

[Asheesh]

Hi Mita,

Your criteria 2 (cell H3) in the image says 95000..but i dont see 95000 in column B & C for Criteria 1 as b..

Can you please give an example ..

 

[Khalid NGO]

Hi Parmar,
Firstly welcome to the forum Chandoo.org

Further to what Asheesh said, try sharing your problem in details as much as you can. What is criteria 2 ?
1) Either it is equal to 95000
2) Less than
3) Less than or equal to
4) Greater than
5) Greater than or equal to
6) Not equal to

Plz clarify and also share your workbook, so that anyone here will happy to help in real time.

Regards,

 

[NARAYANK991]

Hi Mita ,

Try this :

=SUMIFS($D$2:$D$17,$A$2:$A$17,$G$3,$B$2:$B$17,"<="&$H$3,$C$2:$C$17,">="&$H$3)

The SUMIFS function is available only in Excel 2007 and later versions.

Narayan

 

[mita parmar]

Hi Mita ,

Try this :

=SUMIFS($D$2:$D$17,$A$2:$A$17,$G$3,$B$2:$B$17,"<="&$H$3,$C$2:$C$17,">="&$H$3)

The SUMIFS function is available only in Excel 2007 and later versions.

Narayan

hi Narayan,
many thanks for your help - that gives me exactly what I needed
your a star !

regards,