Formula help needed with looking up and if condition

[abdulhaque]

Frequency	Per Year	Per Month
Monthly	£5,940.72	£495.06
Yearly	£194.28	£16.19
Monthly	£74.76	£6.23
Monthly	£180.00	£15.00
Monthly	£96.00	£8.00
Yearly	£518.01	£43.17
Yearly	£200.00	£16.67
Yearly	£50.00	£4.17
Monthly	£3,450.84	£287.57
			Per month total only if frequency is Monthly	0

<tbody>
</tbody>

I'm trying to calculate the sum of the Per Month field, but only if the corresponding Frequency is set to Monthly.

 

[circledchicken]

Hi abdulhaque and welcome to the forum,

You can try the SUMIF function, something like this:

Book1
	A	B	C
2	Monthly	5940.72	495.06
3	Yearly	194.28	16.19
4	Monthly	74.76	6.23
5	Monthly	180	15
6	Monthly	96	8
7	Yearly	518.01	43.17
8	Yearly	200	16.67
9	Yearly	50	4.17
10	Monthly	3450.84	287.57
11
12	Per month total		£811.86
Sheet1

Cell Formulas
Range	Formula
C12	=SUMIF(A2:A10, "Monthly", C2:C10)

 

[abdulhaque]

Worked a treat, thanks a lot

 

[circledchicken]

You're welcome.