Many criteria with ifs finction

Rfire777  wrote:  ``I am still not able to get the result , still facing formula phase error``

You are using Google Sheets, not Excel.  You should post to a Google Sheets forum.

-----

Rfire777  wrote:  ``Attaching the screenshots``

If a "picture is worth a 1000 words", an Excel (or Google Sheets) file is worth 1000 pictures.

In Google Sheets, a #ERROR error indicates a syntax error (click here).  It could be something very subtle.

Provide a download URL for the Google Sheets file so that we can copy-and-paste the text of the formula.

Do you usually use comma (",") to separate function parameters?  As an experiment, what does =SUM(H3,I3) return:  46999?

PS....  You still did not correct the last condition so that you will not get a #N/A error, when you finally get past the #ERROR error.  Reread my previous response.