P
PIP1666
Hi all,
New to this forum and desperately need some help soon as I have to wor
out average profits for our company in about oooh about 11 hours.
thought at first excel would have an in built function for this bu
noooo.
It does seem like an easy problem but I’m stuck. Please help before
have to go groveling to my boss.
This is the problem:-
COLUMN/ROW A B C
1 20 £3.30 1
2 10 £3.50 1182
3 2 £3.50 1194
4 1 £3.50 1
5 2 £3.50 1139
For those cells in Column C that are 1 (i.e in this case C1 and C4)
must add the products of that in A and B (i.e (20*3.3)+(1*3.5))
I tried SumProduct but cant get anywhere and can’t just do it the lon
way and add another column in because 1. there is about 1000 othe
columns in other sheets and 2. I’m lazy. I must have it calculate
using just one cell.
Pretty please with sugar on the top please hel
New to this forum and desperately need some help soon as I have to wor
out average profits for our company in about oooh about 11 hours.
thought at first excel would have an in built function for this bu
noooo.
It does seem like an easy problem but I’m stuck. Please help before
have to go groveling to my boss.
This is the problem:-
COLUMN/ROW A B C
1 20 £3.30 1
2 10 £3.50 1182
3 2 £3.50 1194
4 1 £3.50 1
5 2 £3.50 1139
For those cells in Column C that are 1 (i.e in this case C1 and C4)
must add the products of that in A and B (i.e (20*3.3)+(1*3.5))
I tried SumProduct but cant get anywhere and can’t just do it the lon
way and add another column in because 1. there is about 1000 othe
columns in other sheets and 2. I’m lazy. I must have it calculate
using just one cell.
Pretty please with sugar on the top please hel