Sumif with multiple cell groups not consecutive to each other

[emiliopena2]

so i have the sheet that im using this formula =SUMIF(F33:F37,"X",G$33:G$37) and this works good but i need to add 2 other groups of cells, so like this but this doesnt work =SUMIF(F33:F37,"X",G$33:G$37)=SUMIF(I33:I37,"X",J$33:J$37)=SUMIF(L33:L35,"X",M$33:M$35) let me know if you need more information. Thanks for the help.

[Jonmo1]

Can you post a sample book?

If there are no X's in columns G H, or J K
Then you can just do

=SUMIF(F33:L37,"X",G$33:M$37)

[emiliopena2]

But there is X's there and i need the option to have X's sometimes and other times no X's.
Attached is a sample.

[Jonmo1]

I don't see any X's in columns G H J or K

This in A1 returns 39
=SUMIF(F2:L6,"x",G2:N6)

[emiliopena2]

Thanks so much that perfect!!!! marked this as solved!!!

[Jonmo1]

You're welcome.

[emiliopena2]

how do i change the post to solved?

[Jonmo1]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.