1 min readfrom 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?

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

Want to read more?

Check out the full article on the original site

View original article