Sorry,

A Typo Mistake, consider the revised one. Only a place of closing parentesis
changed.

=SUMPRODUCT(--('1'!A:A="CRITERIA 1")*--('1'!B:B="CRITERIA
2")*--('1'!C:C="CRITERIA 3"),'1'!J:J)

--

Best Regards,
FARAZ A. QURESHI


"albertmb" wrote:

Thank you for your fast reply, but the formula is giving me the #NUM error.
Can it be I misunderstood something?

Regards
Albert

"FARAZ QURESHI" wrote:

Try the following pattern:

=SUMPRODUCT(--(€˜1!A:A="CRITERIA 1")*--(€˜1!B:B="CRITERIA
2")*--(€˜1!C:C="CRITERIA 3",€˜1!J:J))

It would give you the total of amounts in J of the rows which have the cells
in Column A, Column B AND Column C met.
--

Best Regards,
FARAZ A. QURESHI


"albertmb" wrote:

Hi to all,
Wonder if you can help me. I have the following formula which works ok, is
it possible to have a similar formula but with extended choice of cells:

SUMIF('1'!A:A,A5,'1'!J:J)

Example: The present formula will compare €˜1!A:A with A5, I would like a
formula to compare €˜1!A:A,A5 and €˜1!B:B giving the same result from €˜1J:J

€˜1!A:A being a category like €œTravel Expenses€�,
€˜1!B:B being a department like €œSales Department€�
€˜1!J:J being the €œCost€�

Thank You

Albert