Help with a formula please

[deemer98]

If B7:B10,B12:B15,B17:B20,B22:B25,B27:B30,B32:B35,B37:B39,B42:B45,B47:B50,B52 are not null, I want C2 to add 300 each time I add a number to one of those cells regardless of what the number is.

Example: If B7 has 125 in it, C2 needs to say 300. If I then make B8 say 539, C2 needs to add another 300 for a total of 600 and so on.

Thank you!

 

[DanteAmor]

Try:

Dante Amor
	A	B	C	D
1
2
3			1200
4
5
6
7
8		x
9
10
11
12
13
14		y
15
16
17
18
19
20		z
21
22		1
23
24
25
Hoja5

Cell Formulas
Range	Formula
C3	C3	=COUNTA(B7:B10,B12:B15,B17:B20,B22:B25,B27:B30,B32:B35,B37:B39,B42:B45,B47:B50,B52)*300

 

[deemer98]

Well that was pretty straightforward LOL. I was stuck in my own head with a COUNTIF formula! Thank you Dante!