Using SumIFS with a named range as criteria

[madmiddle]

Good evening,

I have created budget spreadsheet for myself and i'm just trying to tidy it up a bit. what i would like is count the amount in colum O when a certain word is present in column P, then when it's found that word search for the next one in named range 'income'.

I have searched for a couple of days but there doesn't seem to be much on sumifs.

the code is was using is:

=SUMIFS($P:$P,$O:$O,Income)

I tried:

=SUMPRODUCT(SUMIFS($P:$P,$O:$O,Income))

but i don't think that is right either.

any suggestions??

Thank you in advance

Andy

 

[madmiddle]

Yes, just make sure they are all vertical vectors.

Thank you very much for your help.

 

[pgc01]

You're welcome. Thanks for the feedback.