gigifarrow

asked on

# Not understanding how a excel fromula caldulates

I have a excel formula that I need to transfer to a access formula but i dont understand the formula what it means or how it is calculating.

equavalent vehicle complete is the Name of the field that it is calculating and this is the formula

=SUMIF($D$31:$D$395,"="&D4,$AE$31:$AE$395)

column d31- d395 are name of units like FY9 or fy10

column ae31-ae395 are percentages some are 100% SOME ARE 10 % and 5% AND SO ON

equavalent vehicle complete is the Name of the field that it is calculating and this is the formula

=SUMIF($D$31:$D$395,"="&D4

column d31- d395 are name of units like FY9 or fy10

column ae31-ae395 are percentages some are 100% SOME ARE 10 % and 5% AND SO ON

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

I don't see any formulas in that sheet - can you give a specific formula that you believe is mis-calculating?

If you are using the formula from your question, i.e.

=SUMIF($D$31:$D$395,"="&D4,$AE$31:$AE$395)

then because D4 is blank that will sum all the AE column values where the corresponding cell in column D is blank

regards, barry

If you are using the formula from your question, i.e.

=SUMIF($D$31:$D$395,"="&D4

then because D4 is blank that will sum all the AE column values where the corresponding cell in column D is blank

regards, barry

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Sorry about that. Been busy I had copied and pasted it and I didnt know that the formulas would not show up here is the formulas.

The field is called vehicle:equavalent vehicle complete

BUSK-III-FS3--STATUS-REPORTforhe.zip

The field is called vehicle:equavalent vehicle complete

BUSK-III-FS3--STATUS-REPORTforhe.zip

So then the info we posted should help you build your equivalent Dsum() formula

Hi gigifarrow it looks like your SUMIF works fine, why do you think it is not working?

ASKER

And the fields that are supose to total i have them highlihted also.

exampleofvehicleequivalent.xlsx