View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default SUM if the conditions are met

In D2:
=SUMPRODUCT((A2:A10=--"23 Oct 2007")*(C2:C10="X"),B2:B10)
Adapt the ranges & criteria to suit
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Mortir" wrote:
I have the following case

A B C
1 Date Value Mark
2 23.10.2007 100 X
3 23.10.2007 150
4 23.10.2007 200
5 23.10.2007 300 X
6 24.10.2007 123
7 24.10.2007 344
etc...

Now I would like to have a formula which would sum the values on a
certain date, that are marked with an X. For example, the result on
23.10.2007 would sum only 100+300=400