![]() |
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. |
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. |
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 06:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com