Conditional Sum

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I am using Conditional Sum function.
For example my table like that;
TYPE QUANTITY COST
sugar 15 1,15TL
tea 13 2,23TL
apple 35 1,18TL

We sum the column named "cost"
two conditions is added;
1- cost=2,23
2- type="sugar"

But I get the error message;
"run-time error '1004':
Unable to set the FormulaArray property of the Range class"

If I remove the commas from the "cost" field, "conditional formatting" is
run, does not get error.

How can I resolve the problem.
Thanks.
Sevgi.
 
Hi

i'm confused when you say you "sum the column cost" - don't you want to sum
"Quantity"?

Cheers
JulieD
 
Back
Top