help with excel formula - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HotUKDeals, you accept our cookie and privacy policy.
Get the HotUKDeals app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit

help with excel formula

£0.00 @
I used to be a whizz at these things, but i'm having a mental block, might just be because i'm hungover. anyway what i'm trying to do is. add cells f3 & g3, add cells h3 to L3 then minus h3:L3 f… Read More
fwibble Avatar
1d, 2m agoPosted 1 decade, 2 months ago
I used to be a whizz at these things, but i'm having a mental block, might just be because i'm hungover.

anyway what i'm trying to do is.

add cells f3 & g3, add cells h3 to L3 then minus h3:L3 from f3 & g3 :?

what I had was =sum(h3+g3)-(h3:L3)...

I know this is going to be unbelievably simple and i will look like a dumn mule.

but I'm blaming the consumption of many pints of Fosters followed by many a class of JD+Coke... leaving me feel a bit blurgh today..

anyway thanks and rep will be left for the first few that help
fwibble Avatar
1d, 2m agoPosted 1 decade, 2 months ago
Options

All Comments

(9) Jump to unreadPost a comment
Comments/page:
1 Like #1
=(f3+g3)-sum(h3:l3)

That should do the trick
#2
I think this might work, but it's a bit long winded:

=F3+G3+(H3+I3+J3+K3+L3)-((F3+G3)-(H3+I3+J3+K3+L3))
#3
=SUM(F3:G3)-SUM(H3:L3)

done this which works can it be tided any beter than this though

edit: forgot to say thanks, so thanks emma
#4
=f3+g3+sum(h3:l3)-((f3+g3)-sum(h3:l3))
#5
fwibble
=SUM(F3:G3)-SUM(H3:L3)

done this which works can it be tided any beter than this though

edit: forgot to say thanks, so thanks emma


Am i invisible here ? :-D
1 Like #6
I think I misunderstood what you were trying to get. :?
#7
sorry midmac didn't scroll up enough will leave rep in a mo
#8
fwibble
sorry midmac didn't scroll up enough will leave rep in a mo

LoL Its ok mate :thumbsup:
#9
rep left

Post a Comment

You don't need an account to leave a comment. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!