B
Bob
All,
Currently I'm trying to calculate values based on the following (and having
zero luck): I have a sheet with multiple part numbers and global locations,
and the associated quantities. So it might read:
Zimbabwe | 95-049563-01 | 3
Taiwan | 95-049563-01 | 2
The last thing I was able to find online was an array formula using sums,
which looked like so:
{=SUM((A2:A7807="Zimbabwe")*(C2:C7807="95-049563-01")*G2:G7807)}
I don't get an error when I complete this, but it always tallies to zero.
I'd appreciate any help anyone can give at all. Thanks!
Sincerely,
Bob
Currently I'm trying to calculate values based on the following (and having
zero luck): I have a sheet with multiple part numbers and global locations,
and the associated quantities. So it might read:
Zimbabwe | 95-049563-01 | 3
Taiwan | 95-049563-01 | 2
The last thing I was able to find online was an array formula using sums,
which looked like so:
{=SUM((A2:A7807="Zimbabwe")*(C2:C7807="95-049563-01")*G2:G7807)}
I don't get an error when I complete this, but it always tallies to zero.
I'd appreciate any help anyone can give at all. Thanks!
Sincerely,
Bob