SUM IF sum of two collumns

  • Thread starter Thread starter petran
  • Start date Start date
P

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??
 
Pleasse don't SHOUT !!

Have you tried:

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

?

Hope this helps.

Pete
 
Back
Top