ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   adding two colum cells only if there is data in 3rd colum (https://www.excelbanter.com/excel-worksheet-functions/247009-adding-two-colum-cells-only-if-there-data-3rd-colum.html)

stbob

adding two colum cells only if there is data in 3rd colum
 
add cells in two columns only if there is data in a third column

ryguy7272

adding two colum cells only if there is data in 3rd colum
 
Is this what you are after?
In CellD3:
=IF(C1<"",A1+B1,"")

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"stbob" wrote:

add cells in two columns only if there is data in a third column



All times are GMT +1. The time now is 06:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com