Hi - what is wrong with this formula? I have used it successfully with sumproduct?
=SUMIF(H8:H106,--($B$8:$B$106="CARU")--($D$8:$D$106="Medical"))
Trying to add a column which contains the words CARU in one column and Medical in another...
Thank you,
Catherine