All,
I hope someone can help me as I am going nuts trying to sort out a SUMPRODUCT function.
Spread sheet as follows:
Column A: Date (e.g. 01/01/06)
Column B: Type of product (e.g. camera, lens, etc)
Column C: Cost of product (£)
What I want to do is sum column C for all cameras in January. I have used the SUMPRODUCT function which almost works almost OK:
=SUMPRODUCT((A2:A10=01/01/06)*(B2:B10="camera"),C2:C10)
This is great if I want to know total value of cameras on one specific date (e.g. 01/01/06) but I want to calculate the total value of all cameras between two dates (i.e. all of January).
Can I somehow implement A2:A10>01/01/06 AND <02/02/06 in the above function? I have tried and failed!
I hope someone can help me as I am going nuts trying to sort out a SUMPRODUCT function.
Spread sheet as follows:
Column A: Date (e.g. 01/01/06)
Column B: Type of product (e.g. camera, lens, etc)
Column C: Cost of product (£)
What I want to do is sum column C for all cameras in January. I have used the SUMPRODUCT function which almost works almost OK:
=SUMPRODUCT((A2:A10=01/01/06)*(B2:B10="camera"),C2:C10)
This is great if I want to know total value of cameras on one specific date (e.g. 01/01/06) but I want to calculate the total value of all cameras between two dates (i.e. all of January).
Can I somehow implement A2:A10>01/01/06 AND <02/02/06 in the above function? I have tried and failed!