Skip to Content
0
May 11, 2018 at 12:57 PM

Formula not working. Please help

87 Views

Hello All,

i am facing issue with a formula

Pay/rec Voted

REC 1.00
REC 104,250.00
REC 0.00
PAY 20,000.00
PAY 1,700.00
PAY 20,000.00
PAY 2,000.00

-----------------------------------

1,47,951

-----------------------------------

I need to find sum on PAY and REC. So i have written the formula like this.

If Pay/rec = 'REC'

then sum (Voted ) .

With this i need to get only REC Amount i.e 1,04,251.00

But i am getting 1,47,951.00.Can you please let me know where am i doing a mistake.

Thanks

Radhika