ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   sum only if a certain cell contains a date (https://www.excelbanter.com/excel-worksheet-functions/250649-sum-only-if-certain-cell-contains-date.html)

mimsly17

sum only if a certain cell contains a date
 
I am trying to include a figure in a sum but I only want to count it if a
date appears in another cell.



T. Valko

sum only if a certain cell contains a date
 
How about providing some details?

--
Biff
Microsoft Excel MVP


"mimsly17" wrote in message
...
I am trying to include a figure in a sum but I only want to count it if a
date appears in another cell.





Fred Smith[_4_]

sum only if a certain cell contains a date
 
Something like:
=a1+if(b10,c1,0)
?

Regards,
Fred.

"mimsly17" wrote in message
...
I am trying to include a figure in a sum but I only want to count it if a
date appears in another cell.





All times are GMT +1. The time now is 01:46 AM.

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