Thread: Need Sum of 2 columns if one is filled?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Cone[_2_] Jim Cone[_2_] is offline
external usenet poster
  
Posts: 1,549
Default Need Sum of 2 columns if one is filled?
=SUMPRODUCT(--(M2:M165<0.001),E2:E165)+SUM(M2:M165)
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"TKGerdie"
wrote in message
I need help with a formula. I have two columns - E (projected revenue) and M
(actual revenue). If M has a total in it, I want to ignore the same row in
E, so that the actual revenue is added in to the total sum at the bottom
along with the projected (if there isn't an actual amount) in column M. The
sum is E166. The columns are E2:E165 and M2:M165.
Reply With QuoteReply With Quote