Jan 28 2022 08:32 AM
Hello All
Needing some help
I have a large multi-worksheet document with multiple tables all gathering info from each other through different formulas and document links
Here is what I am trying to do
Column A in table 51 has a list of asset numbers. Column B in Table 51 needs to show data calculated from column P in Table 3 IF column F in Table 3 has a specific asset number listed. If there are multiple instances of the unit number listed in column F of Table 3, the data from each instance in Column P of Table 3 needs to be added together then listed in the correct corresponding asset number cell in Table 51.
Does that make sense?
Jan 28 2022 08:46 AM
@lorie3345 To be honest, it's all a bit vague. But when you say "the data from each instance in Column P of Table 3 needs to be added together" it seems you are looking at numerical values in "column P. Look into the SUMIF and/or SUMIFS functions.
Jan 28 2022 09:01 AM
Jan 28 2022 09:03 AM
Jan 28 2022 09:14 AM - edited Jan 28 2022 09:16 AM
@lorie3345 A spill error means that you have a recent Excel version. Spilling means that Excel tries to put a result in multiple cells in one go, but it can't as something is in the way. Would have to see your file. Perhaps Power Query would be worth looking into. But again, I can't tell without seeing the file.
Jan 28 2022 09:42 AM
Jan 28 2022 09:51 AM
@lorie3345 You can send it to me via a direct message. No guarantees though that I'm going to look at it tonight. I'm on CET and it's diner time. Thereafter, ice hockey.
Jan 28 2022 09:53 AM