SUM IF sum of two collumns

[petran]

I have the following worksheet

COLLUMNS
A EURO/BGN
B PAYMENT EURO A
C PAYMENT BGN A
D PAYMENT EURO B
E PAYMENT BGN B

I WANT TO SUM ALL THE PAYMENT IN EURO (FROM THE COLLUMNS B AND D) IF THE
CRITERIA FROM THE COLUMN A IS EURO
I TRIED BUT I CANNOT DO. WITH SUMIF FUNCTION I CAN ONLY SUM EITHER COLUMN B
OR D, NOT THE TWO OF THEM TOGETHER.
CAN SOMEBODY HELP ME??

 

[Pete_UK]

Pleasse don't SHOUT !!

Have you tried:

=SUMIF(on column B) + SUMIF(on column D)

?

Hope this helps.

Pete

 

[Mike H]

Try,

=SUMPRODUCT((A2:A40="Euro")*(B2:B40+D240))

Mike