How to find Average Salary according to the Month

2 views
Skip to first unread message

Pratibha Sharma

unread,
Oct 2, 2015, 7:56:47 AM10/2/15
to Excel VBA Lab
Dear All,

How to find average salary according to the Month.


Query sheet is attached.


Kindly provide the support.




Thanks & Regards
PS
Average.xlsx

Ashish Bhalara

unread,
Oct 2, 2015, 11:48:46 PM10/2/15
to Excel VBA Lab
Hello Pratibhaji,

Try below function for sum of July as per your sheet.
=SUMIF(D2:D13,">="&DATE(2013,7,1),E2:E13)-SUMIF(D2:D13,">"&DATE(2013,7,31),E2:E13)

If you want to SUM from different Date range, type first Date in cell I1 and second date in cell J1 and use below function.
=SUMIF(D2:D13,">="&I1,E2:E13)-SUMIF(D2:D13,">"&J1,E2:E13)

Regards
Ashish Bhalara

--
www.ExcelVbaLab.com
---
You received this message because you are subscribed to the Google Groups "Excel VBA Lab" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ExcelVbaLab...@googlegroups.com.
To post to this group, send email to Excel...@googlegroups.com.
Visit this group at http://groups.google.com/group/ExcelVbaLab.
To view this discussion on the web visit https://groups.google.com/d/msgid/ExcelVbaLab/32bea2fe-adde-4824-a522-57b121005b19%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Pratibha Sharma

unread,
Oct 3, 2015, 12:04:44 AM10/3/15
to Excel VBA Lab
Dear Ashish Bhalara,

Thanks for your help.

The formula which is shared by you is working for Sum calculation for the month of July.

I want to calculate average salary for the month of July.

Kindly help and suggest other formula for the same.


Thanks & Regards
PS

Ashish Kumar

unread,
Oct 3, 2015, 1:16:29 AM10/3/15
to Excel...@googlegroups.com
Hi,


Please Visit on Group Page for download the Sheet & Check the answer.




Regards
Ashish Kumar
Average.xlsx

Ashish Bhalara

unread,
Oct 3, 2015, 2:08:52 AM10/3/15
to Excel VBA Lab
Hi,

Sorry, I forget your query during solution, Mr.Ashish Kumar gave a perfect solution of your query.

Regards
Ashish Bhalara

--
www.ExcelVbaLab.com
---
You received this message because you are subscribed to the Google Groups "Excel VBA Lab" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ExcelVbaLab...@googlegroups.com.
To post to this group, send email to Excel...@googlegroups.com.
Visit this group at http://groups.google.com/group/ExcelVbaLab.
To view this discussion on the web visit https://groups.google.com/d/msgid/ExcelVbaLab/13207c89-2b0f-4168-8332-72b98cf63ba4%40googlegroups.com.

Ashish Kumar

unread,
Oct 3, 2015, 2:16:58 AM10/3/15
to Excel VBA Lab
Dear Ashish Bhalara,

Thanks for Acknowledge.



Regards
Ashish Kumar

Pratibha Sharma

unread,
Oct 5, 2015, 5:55:55 AM10/5/15
to Excel VBA Lab
Dear Ashish Kumar,

I am looking for this only. Thanks for the solution :)


@ Ashish Bhalara,

Thanks you for your support.





Thanks & Regards
PS

Ashish Kumar

unread,
Oct 5, 2015, 6:47:23 AM10/5/15
to Excel VBA Lab
Welcome...!!



Regards
Ashish Kumar
Reply all
Reply to author
Forward
0 new messages