Hi,
I am trying to sum a column based on two criterias from two different columns. Below is the formula I am trying to use:
If Col B has a word GROSS and Col C has Goldservice, I want Excel to SUM all the numbers in Col D.
Formula above is returning #N/A. I have trying in all different ways but now working. Can you please help? Thank you.
I am trying to sum a column based on two criterias from two different columns. Below is the formula I am trying to use:
Code:
=SUMPRODUCT(('GROSS Contracts'!B5:B191="GROSS")*('GROSS Contracts'!C5:C191="Goldservice")*'GROSS Contracts'!D5:D253)
If Col B has a word GROSS and Col C has Goldservice, I want Excel to SUM all the numbers in Col D.
Formula above is returning #N/A. I have trying in all different ways but now working. Can you please help? Thank you.