Formula issue

pmolloy

Hi,

Im trying to SUM the amount in Infrateq Pre-Sales Days Used column if the name is correct in Infrateq Pre-Sales assigned column. but I keep getting ERROR

=SUMIF([Infrateq Pre-Sales assigned]:[Infrateq Pre-Sales assigned] "Amr Safwat", [Infrateq Pre-Sales Days Used]:[Infrateq Pre-Sales Days Used])

Bassam Khalil

Hi @pmolloy,

please try the following formula ( copy the code and paste it in the cell for sum formula )

=SUMIF([Infrateq Pre-Sales assigned]:[Infrateq Pre-Sales assigned], @cell = "Amr Safwat",
[Infrateq Pre-Sales Days Used]:[Infrateq Pre-Sales Days Used])

following is a screenshot shows the result

Anjanesh Vaidya

Hi pmolloy,

You can use the following formula. I have corrected a syntax error in it and its working for me.

=SUMIF([Infrateq Pre-Sales assigned]:[Infrateq Pre-Sales assigned], "Amr Safwat", [Infrateq Pre-Sales Days Used]:[Infrateq Pre-Sales Days Used])

Thank You,

Anjanesh Vaidya

Leela Lodhi

Hi @pmolloy,

It seems the comma is missing after the range, Please add a comma and try again.

Try this:

=SUMIF([Infrateq Pre-Sales assigned]:[Infrateq Pre-Sales assigned], "Amr Safwat", [Infrateq Pre-Sales Days Used]:[Infrateq Pre-Sales Days Used])

pmolloy

Wow amazing. Thank you for your help :)