Advice Request [Solved] Excel Formulas

Please provide comments and solutions that are helpful to the author of this topic.

Status
Not open for further replies.
D

Deleted member 178

Thread author
ok guys,

im really a noob with excel, so i need to do this:

- create a formula that will sum (in "Total" cell) the amount in "Price" cells

ugCQRvr.png


then this formula will repeat for every lines under (each line been a day)

thanks
 

CMLew

Level 23
Verified
Well-known
Oct 30, 2015
1,251
umm.. "=D3+G3+J3+M3+P3+S3" ?

Then drag U-row to bottom.

Is that what you wanted?
 
D

Deleted member 178

Thread author
umm.. "=D3+G3+J3+M3+P3+S3" ?

i did that , "Total cell" show "#value" ...

edit : omg ! this stupid Excel doesn't consider spaces between numbers ... 100000 but not 100 000...

thx @CMLew

Question solved, Thread closed.
 
Last edited by a moderator:
Status
Not open for further replies.

About us

  • MalwareTips is a community-driven platform providing the latest information and resources on malware and cyber threats. Our team of experienced professionals and passionate volunteers work to keep the internet safe and secure. We provide accurate, up-to-date information and strive to build a strong and supportive community dedicated to cybersecurity.

User Menu

Follow us

Follow us on Facebook or Twitter to know first about the latest cybersecurity incidents and malware threats.

Top