Hello everyone
I have a question about this function. Does the second criteria range has to be different to the first one?
=SUMIFS(C:C;D:D;"Zloty";D:D;"GBP")
I am using this one where I have all the amounts in C:C (Sum range) then in D:D I have the currency.
PS I know it does not make any sense to add up zlotys and pounds together
Thank you
Bookmarks