SUM 2 COLUMNS based on condition

Hello,

I need to sum the values in 2 columns (COL A and COL C) row-by-row IF both cells in each row (of COL A and COL C) have a value greater than 0. I cannot put the columns together because the data is being pulled from a Pivot Table.

EXAMPLE:

COL A	COL B	COL C
5	unrelated data	10
3	unrelated data
	unrelated data	7
2	unrelated data	17
	unrelated data	1
3	unrelated data

The total should come to 34. I was thinking SUMIFS but that won't work since it only sums on a single range. I started trying the SUMPRODUCT formula, but am not getting anywhere. Thanks for any help.

Try

=SUMPRODUCT(--(A2:A7>0),--(C2:C7>0),A2:A7+C2:C7)

Works perfect! Thank you for solving my problem!

You're welcome.