Hi folks,
I'm having an sum & "lookup" problem, not finding what function(s) in front end Excel to sum only amount of Salary codes with "FG" = X in column D in sheet 2. The formula should be written somewhere in sheet 1. See attachment. It's supposed to be a scalable solution, therefore function is needed.
Also, I need VBA code with same kind of sum & lookup possibility for "PG" = X and "AG" = X cases, but then in back end of Excel (VBA/macro), only summing amounts where Salary code is "PG" = X or "AG" = X.
Thanks if any can help with suggestion to Excel formulas and/or VBA code.
Trond
Hi Trond
Unable to download your attachment.
Can you try to upload it again?
Attachment uploaded again
(please say if not available this time too).
Trond
Hi Trond
Your attachment is not clear enough. There are no values in sheet 2.
Please give examples of your expected result and where you got them from.
