View Single Post
  #5   Report Post  
Lilliabeth
 
Posts: n/a
Default


Your function is looking for a T in the range E22:E30, but summing
F31:F32.

Change it to =7.5%*SUMIF(E22:E30,"T",F22:F30)

Or, if you are really taxing tax,
=(7.5%*SUMIF(E22:E30,"T",F22:F30))+(7.5%*F32)


--
Lilliabeth
------------------------------------------------------------------------
Lilliabeth's Profile: http://www.excelforum.com/member.php...o&userid=27741
View this thread: http://www.excelforum.com/showthread...hreadid=472385