Level 1

0% to

Level 2

Tip /

to gain points, level up, and earn exciting badges like the new
Mission!

View all

## Trying to get a calculation to take the data in one field and depending on what it is adding the information to a total field. there are multiple lines in this document.

Level 1

Likes

0 likes

Total Posts

1 post

0 solutions
View profile

Level 1

Likes

0 likes

Total Posts

1 post

0 solutions
View profile
Level 1

18-10-2018

I am trying to get a sumif statement to work in three different fields.  The data is located in two separate fields in the form.  Rate and Miles.  There are 31 lines on this form that can contain data in these fields that needs to be included in the appropriate field below:

1. If “Rate” = S add to Standard (S) Miles Take
information in corresponding line in field MILES and add to Line 34 TOTAL
STANDARD MILES
2. If “Rate” = F add to Fleet (F) Miles Take information
in corresponding line in field MILES and add to Line  Line 35 TOTAL FLEEET MILES
3. If “Rate” = R add to Rental( R) Miles Take information
in corresponding line in field MILES and add to Line  Line 36 TOTAL RENTAL MILES

Mayank_Gandhi
Level 10

Likes

327 likes

Total Posts

1,153 posts

185 solutions
View profile

Mayank_Gandhi
Level 10

Likes

327 likes

Total Posts

1,153 posts

185 solutions