 # Get instant live expert help on I need help with excel calculated item “My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

calculated item formula is including blanks in averages
Solved by F. S. in 21 mins
Calculate the total quantity sold per category in range D32:D51 based on the item in column B. Once this has been calculated, the total quantity delivered and ending inventory can be calculated. In cell D32, create a formula to sum the range Trans_Sold from the DailyTransactions worksheet if the criteria in B32 is found in the range Trans_Item from the DailyTransactions worksheet.
Solved by B. B. in 25 mins
sir,in excel sheet same item is 5 but rate is change of 5 item pls tell me remove same 4 item and rate is high
Solved by K. S. in 26 mins
pivot table calculated field is not working in excel Help
Solved by G. C. in 18 mins
I have multiple accruals on a PO that I need to track. I summarize this in a pivot table. I added a remaining budget column as a calculated field. This works fine if the PO has a single entry in the master table. If there're multiple entries, the accrual is deducted from the first line item and subsequent PO amounts are added to the remainder. How to fix the calculated field?
Solved by V. H. in 30 mins