Calculate average $/HR by pulling data from two workbooks
Closed
chouston
Posts
1
Registration date
Monday March 25, 2013
Status
Member
Last seen
March 25, 2013
-
Mar 25, 2013 at 05:41 PM
sgmpatnaik Posts 52 Registration date Tuesday April 2, 2013 Status Member Last seen November 27, 2013 - Apr 29, 2013 at 07:47 AM
sgmpatnaik Posts 52 Registration date Tuesday April 2, 2013 Status Member Last seen November 27, 2013 - Apr 29, 2013 at 07:47 AM
Related:
- Calculate average $/HR by pulling data from two workbooks
- Tmobile data check - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Display two columns in data validation list but return only one - Guide
- Gta 5 data download for pc - Download - Action and adventure
- How to calculate fuel surcharge - Excel Forum
1 response
sgmpatnaik
Posts
52
Registration date
Tuesday April 2, 2013
Status
Member
Last seen
November 27, 2013
45
Apr 29, 2013 at 07:47 AM
Apr 29, 2013 at 07:47 AM
HI
Please Try the below formula for average calculation for book1
in I4 write the below formula
I4: =AVERAGEIF($E$2:$E$70,$h4,$D$2:$D$70)
and copy across
and for second thing i can't understand can you elaborate me once again
Thanks
Patnaik
Please Try the below formula for average calculation for book1
in I4 write the below formula
I4: =AVERAGEIF($E$2:$E$70,$h4,$D$2:$D$70)
and copy across
and for second thing i can't understand can you elaborate me once again
Thanks
Patnaik