Averageif with multiple cells

[kumara_faith]

Hi,

I have the following table:

Book1
	A	B	C
1	Table 1
2	Date	Branch	Revenue
3	1/1/2023	Texas	1,500
4	1/1/2023	Texas
5	1/1/2023	Texas	1,354
6	1/1/2023	Texas	1,478
7	1/1/2023	Texas
8			1,444
9
10	Table 2
11	Date	Branch	Revenue
12	1/1/2023	New York	1,500
13	1/1/2023	New York	1,500
14	1/1/2023	New York
15	1/1/2023	New York	1,478
16	1/1/2023	New York	1,500
17			1,495
18
19	Table 3
20	Date	Branch	Revenue
21	1/1/2023	Iowa
22	1/1/2023	Iowa
23	1/1/2023	Iowa
24	1/1/2023	Iowa
25	1/1/2023	Iowa
26			0
27
28	Table 4
29	1/1/2023	Summary
Sheet1

Cell Formulas
Range	Formula
C8,C26,C17	C8	=IFERROR(AVERAGEIF(C3:C7,">0",C3:C7),0)

Table 1-3 are the input tables. In Table 4,in cell C29, I am trying to calculate the average of cell C8, C17 and C26. The average should ignore the cell if the cell is blank or zero. In the above, the correct average is 1469. I tried using averageifs but I am not sure how to nest all the different cells in the formula. I appreciate any help.

 

[kumara_faith]

Thank you Alex for your patience and guidance. Appreciate it and have a great day.

Thank you too to Jason, shift-del, James and awoohaw

 

[Alex Blakenburg]

Thank you for acknowledging all contributors, that is greatly appreciated.