Formula Assistance

[Neffy]

Hello,

I need some help regarding formula-ing this.
It goes something like this !
Hopefully i made sense, if not, let me know and i'll attempt to clarify it.

Table 1

Date	Department	Seconds	Purchased	etc	etc
18 July 2018	Home	500	1	as	fs
19 August 2018	Phone	100	2	asf	sf
19 August 2018	Home	500	1	s	s
20 August 2018	PC	700	4	h	gs
20 August 2018	PC	857	2	d	s
24 August 2018	TV	500	2	s	s
8 September 2018	Home	676	5	s	s

<tbody>
</tbody>

Table 2

Department	Contact	Average Seconds	Purchased
Home	Count how many times Home Appears on the Month (August) so in this case 1 times since it should exclude other months such as July and September	Avg of seconds when Home Appears in the month August (so excluding July September results)	Add of all the purchases in the Purchases Tab in the month of August
Phone
PC
TV

<tbody>
</tbody>

Would that be possible ??

Thank you !

 

[Joe4]

You should be able to do this with SUMIF and COUNTIF formula.
SUMIF will sum values meeting a certain criteria. See: https://www.techonthenet.com/excel/formulas/sumif.php
COUNTIF will count values meeting a certain criteria. See: https://www.techonthenet.com/excel/formulas/countif.php

For an average, you can just divide the results of a SUMIF by the results of a COUNTIF.

 

[Neffy]

I understood the basics but for the COUNTIF formula
but for table 2

B2 cell
how do i get the cell to count if it fulfills 2 conditions?
Count how many "Home" in Column B in "August" in Column A?

 

[Joe4]

There are also COUNTIFS and SUMIFS functions for multiple conditions!
https://www.techonthenet.com/excel/formulas/sumifs.php
https://www.techonthenet.com/excel/formulas/countifs.php