←Back to all posts
•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Running count recommended Formula

I am trying to get a running total on daily log qty. I can't seem to get a formula to work on (Total's Sheet) I want to be able to add to "daily log" and "Totals sheet populates using a Costcode as the cross reference and sums up Qty. By the end of I will have about 40 Cost codes and around 1k entries. What formula is best suited for this? I have tried to use Xlookup, VLookup, and sumif. I can't get any of them to work for me only an error, or "0" populates. Can someone break this down to me in simple terms why one formula is better than the other and when to use it in a situation like this.

(Daily Log) Date/Lead Name/ Cost Code/ Description/ UnitMeasure/Price/QTY/Revenue

(Totals) Costcode/ Description/UnitMeasure/QTY

Thanks

submitted by /u/KiloMarshBoxin
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article→

Tagged with

#AI formula generation techniques
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#Excel compatibility
#no-code spreadsheet solutions
#formula
#running total
#Cost code
#daily log
#Totals sheet
#Xlookup
#VLookup
#sums up Qty
#sumif
#cross reference
#unit measure
#QTY
#entries