2017 Excel - spreadsheet formula - how to not count a negative valve - attached sheet

[Theodore G Kapela]

In this formula =IMSUM(F220,E221,G221), where E221 is a negative number, ( the electric meter went backwards ) the total s/b F220 + G221 only, as that ( -25) is already in G221) .  The correct total in last col. s/b 77.32kw.   I have not be able to figure how to correct formular so that if a number is negative, it is not counted. An "if" or ???

Thank You  if you can, send answer to email address removed for privacy reasons, or note that an answer is available please. 

	42174	7p	54,sun	-6		33.83	758.33		51.83
4/19/23	42199	7a	43,clouds		25
	42174	7p	55,sun	-25		52.32	810.65	*****>>	52.32
4/20/23	42202	9a	45,sun		28

[#2]

@Theodore G Kapela I'm having difficulties understanding the layout of your data. However, using IMSUM is inappropriate. That function deals with complex numbers and can not be used for regular summation of cells.

Perhaps this one does what you need:

=SUM(F220,E221*E221>0,G221)

[#3]

@Riny_van_Eekelen , thank you for reply, but it does not work.  I believe because date is also from an imsub.  I can send you the excel file so you may see how it all fits together. I keep track of my solar and electric this way.  email address removed for privacy reasons

[#4]

Data in col B is a imsub, the only thing that worked to subtract meter readings. Originally tried =sub.