SUMIFS function?

is there a way to sum a column based off of two criteras for the same column.
so say i have numbers in column A and in column B is my critera the options are UG, GU, P, and GG.
i want to sum the numbers in column A if the corresponding cells in column B are UG or GU.

im trying this and its not working
=SUMIFS(A1:A15,B1:B15,"=UG",B1:B15,"=GU")

i think that its not working because im referencing the same cells (column B) twice.

is there another way to make this work? maybe with a OR statement

any help would be awesome

thanks
JED

=SUM(IF(B1:B15={"UG","GU"},A1:A15))

Array entered with Ctrl-Shift-Enter rather than just Enter

Confirmed as:

{=SUM(IF(B1:B15={"UG","GU"},A1:A15))}


Regards, TMS

All options:

=SUM(IF(B1:B15={"UG","GU","P","GG"},A1:A15))

its giving me the #N/A response.
i hit ctrl+shift+enter

do you know why? the values in column A are obtained from functions does this matter?

I can't really comment. I haven't got any data ... your data ... to test it with. Assuming they are numeric values, it should be OK.

The two range sizes need to be the same. If the ranges are different sizes, you'll get #N/A

Regards, TMS