Formula - sumif statement?

[Rachel88]

Hi all,

I'm new to excel, I'm trying to find the value of the following;

Within one tab, I have credit and debits in one column across multiple currencies.

Column 1 - credit/debit
Column 2 - amount
Column 3 - currency

E.g I want the total of credits in EUR's only. This will eventually need to feed on to another tab within my spreadsheet.

Please help!

Thanks

[Special-K]

Try
=SUMIFS(B1:B1000,A1:A1000,"CR",C1:C1000,"EUR")

This assumes that credits are inidcated by CR and currency is indicated by EUR.
If that's not the case change the values to how you have designated them.

[FDibbins]

Hi, welcome to the forum

You didnt really ask a question there - and dont give much info, but based on your title, perhaps this...

=sumifs(B:B,A;A,"Credit",C:C,"EUR")

Adjust the criteria names as needed

If you still have a problem, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

[Rachel88]

Hi all

Thanks for the above, still won't work.

I have two separate formulas that I'd like to combine

=SUMIF(C:C,"credit",I:I) - c being credits/debits, I being amounts, this gives me a total.
=SUMIF(J:J,"EUR",I:I) - j being the currency, this gives me another total

Does this make any sense at all??
Thank you!!!

[greatjobtoday]

It looks like the answer as I understand the question was already posted... you just need to adjust the cell references to your specific columns:

=SUMIFS(I:I,C:C,"credit",J:J,"EUR")

But as mentioned, it would be easier to solve the problem if you post an example file.

Hope that helps!

[FDibbins]

Hi all

Thanks for the above, still won't work.

I have two separate formulas that I'd like to combine

=SUMIF(C:C,"credit",I:I) - c being credits/debits, I being amounts, this gives me a total.
=SUMIF(J:J,"EUR",I:I) - j being the currency, this gives me another total

Does this make any sense at all??
Thank you!!!

1st, what doesnt work? What do you get and what did you expect?
Did you try to adjust my ranges?
Perhaps
=sumifs(I:I,C:C,"Credit",J:J,"EUR")

If that doesnt work for you, help us to stop guessing by uploading a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.