Hi Spottkitty,

Yes, you can use the AVERAGEIF function to exclude blank cells from the calculation. Here's how you can modify your formula:

1. =AVERAGEIF($A$3:$A$45,"Photo",H3:H45)

This formula will only average the values in the range H3:H45 if the corresponding cell in column A contains the text "Photo". Any blank cells in the range will be excluded from the calculation.