•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to multiply categories by numbers while still being attached to a third variable?
I want to calculate how many animals are being caught by my camera traps on a given night, but when there are multiple in one picture, simply creating a pivot table does not seem to work because it only counts the name. I know I can repeat cell values x times, but is it possible to do so while still attaching it to the trap night?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#camera traps
#trap night
#pivot table
#multiply categories
#animals
#calculate
#Excel
#picture
#wildlife monitoring
#multiple entries
#counting
#cell values
#data manipulation
#field data
#data analysis
#statistics
#categorization