•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Countif or sumif when adding from a selection of a drop down and the range is in a different column
Our take
Hi Reddit, I'm working on a project where I need to track machine downtime using a drop-down selection for machines and a separate column for timekeeping. My goal is to visualize this data through a pivot chart, but I'm struggling with the formulas needed to calculate the downtime accurately. Specifically, I need guidance on using COUNTIF or SUMIF to aggregate data from different columns based on the selected machine. Any insights or visual chart examples would be greatly appreciated. Thank you in advance!
Hi Reddit,
I have a column for drop-down selection for machines and another one for time keeping. I'm trying to map out how long each machine is down for and use a pivot chart to make it visual. Any combinations of formulas I come up with come up broken.
Any advice is appreciated - even chart visual.
TYIA
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel alternatives for data analysis#natural language processing for spreadsheets#generative AI for data analysis#rows.com#machine learning in spreadsheet applications#Excel compatibility#real-time data collaboration#financial modeling with spreadsheets#real-time collaboration#Excel alternatives#Countif#Sumif#drop-down selection#pivot chart#column#machines#time keeping#formulas#visualization#Excel