With My excel fileIm having trouble adding a second criteria to a formula
My existing formula is to sum all amounts above a specific word(in this case CAD)
but i would like to add a criteria to sum amounts above the word CAD and that have the word PCD next to the amount
To recap:
Column b = description (this is where the word CAD is located on a specific cell that changes depending on number of entries) /
Column c = amounts that will be summed /
Column d = description (this is where the word PCD is located)
I want to sum all amounts from column c that have the word PCD in column d next to the amounts that are above the word CAD in column b
Existing formula
=SUM(INDIRECT(“C1:C”&MATCH(“CAD”,B:B,0)-1))
