Hi,
Please help me with sumif function... I have different categories of costs which majorityo f them have its own heading... all the rest of them will have to go into one big basket as balancing item.. say
A1 B1 C1
cat descption amounts
100 wages 1
200 power 5
300 gas 2
600 materials 1
800 stationary 10
and i want to sum all of them except cat 100 and 200... can this be done please?
Please help me with sumif function... I have different categories of costs which majorityo f them have its own heading... all the rest of them will have to go into one big basket as balancing item.. say
A1 B1 C1
cat descption amounts
100 wages 1
200 power 5
300 gas 2
600 materials 1
800 stationary 10
and i want to sum all of them except cat 100 and 200... can this be done please?