IF and/or SUMIFS

[Faustocruz]

To multiply a specific number, I do need to have 2 IF's, One is the Type of Operation and the other one to identify the region of operation, I've tried a few options but no one have been successful.

Attached is the file were I'm working and my problem is the Sheet "Report 3" where I've left the formula without the = behind.

Can you pls help on this.

Kind Regards,
Fausto Cruz
FLIGHT FOLIO FOR IPAD IPHONE ANDROID & BLACKBERRY.xlsx

[dilipandey]

Hi Faustocruz,

Your formula is incorrect as per the syntax of SumIF function, see below the correct syntax:-

SumIFs(Range which you need to sum, First Criteira Range, It's Criteria, Second Criteria Range, It's Criteria)

Suggest you to correct the syntax basis above. If you stuck, Provide more clarification. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[Pepe Le Mokko]

I think that is the SUMIFS syntax

[dilipandey]

Thanks Pepe Le Mokko for the heads - up

Corrected the same..

Regards,
DILIPandey

<click on below 'star' if this helps>

[Faustocruz]

Thank you Dilip,

I will try it now and let you guys know.

Rgs
Fausto

[Faustocruz]

I've corrected the syntax and gave an error again.

However, maybe the correct formula is not the SUMIFS but any other one, were I can multiply the D9 at the DATA Sheet with the B31 from the Parameters Sheets but, for that to happen, two values must be in accordance DATA!D4 with Parameters!B28 and DATA!D6 with Parameters!C29, if this two match so than it must multiply DATA!D9 with Parameters!B31. This is where I'm struggling...

[dilipandey]

Ok sure .. I case of any issue, please do post the workbook in which you tried your formula and highlight the ranges , criteria and corresponding range to be summed, so that we can help you better, if required.

Regards,
DILIPandey

<click on below 'star' if this helps>

---------- Post added at 11:51 AM ---------- Previous post was at 11:48 AM ----------

Oh.. you posted before my post..

please do post the workbook in which you tried your formula and highlight the ranges , criteria and corresponding range to be summed, so that we can help you better, if required.

Regards,
DILIPandey

<click on below 'star' if this helps>

[Faustocruz]

Hi Dilip,
Many thank's for your help, were I'm now I do not have internet on my Laptop but on my way to my office and will forward it to your perusal.

Rgs.

[vlady]

Hello Faustocruz
maybe you should delete your e-mail spams will be crowding your mail..
look also here uk/us nautical miles convertion - slight difference.

http://www.metric-conversions.org/le...kilometers.htm

[Faustocruz]

FLIGHT FOLIO FOR IPAD IPHONE ANDROID & BLACKBERRY.xlsx

Hi Dilip,
here I am again.

please find the attached file as discussed, I've tried the IF(and as well and didn't work out...

Rgs.

[dilipandey]

Hi Fausto,

You are using formula :- IF(and(DATA!D9*PARAMETERS!$B$31,(DATA!$D$4=PARAMETERS!$B$28),(DATA!$D$6=PARAMETERS!$C$29)))

I am not getting the logic here

IF(and(DATA!D9*PARAMETERS!$B$31 = what ?

Please right the your logic in brief sentence like :-

If the multiplication of Data!D9 and Parameters!B31 is greater than 500 AND the value of DATA!$D$4=PARAMETERS!$B$28 AND the value of DATA!$D$6=PARAMETERS!$C$29 THEN sum the respective range in Z4:Z29 ELSE leave BLANK

Above is just an explanation of a dummy logic to help you to write down your logic statement. Please provide. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[Faustocruz]

Hi Dilip,

Actually, I did tried everything a know with this formula but no luck.

What I need is: I need to identify if on the cell D4 I will find the word "charter or schedule", and on the D6 I will find the word "domestic" or "regional", if both match then, the D9 must multiply by the parameters B...

I've tried as I've mentioned almost everything and noghing came thru.

Rgs.

[vlady]

maybe like this.

=IF(AND((DATA!$D$4=PARAMETERS!$B$28),(DATA!$D$6=PARAMETERS!$C$29)),DATA!D9*PARAMETERS!$B$31,"")

[Faustocruz]

Dear Vlady,
It is just superb 5*'s

Many thanks to you and who have tried to help me in this regard.

Kind Regards

[vlady]

Your welcome. thanks also. if you have any difficulties just post it here and we'll surely gave a hand.

[Faustocruz]

Thank you.
Rgs.