Text data

[tpmbrian]

Hi

I use this function, which works when I put into the last criteria the text value, in this case Electrician, but when I put Electrician as data into B38 it does not work.

=SUMIFS(H10:H34,H10:H34,"=1",$F10:$F34,"$B38")

Can someone tell me what is wrong with the syntax for the second criteria please?

TPMBrian

 

[asa]

Hi Brian,


Eliminate the quotes around $B38, or else Excel will expect column F to contain the literal text "$B38".


Asa

 

[tpmbrian]

Thanks Asa

That worked

Brian