Can someone please help me with SUMIF, I am losing my mind and keep getting errors.
I have a pipeline document with status' ( approved, declined, awaiting client, in progress,etc) and I need to show in a dashboard the sum associated with each item.
PIPELINE STATUS | dropdown with status'
AMOUNT APPROVED | the dollar amounts per grant
I have tried:
1. =sumif(amount approved:amount approved, "approved", [pipeline status]:[pipeline status]) =#unparseable
2. =sumif([amount approved]:[amount approved], "approved", [pipeline status]:[pipeline status])
= gives me a $0 but should be $37,111
3. =sumif([amount approved]:[amount approved],[pipeline status]:[pipeline status], "approved")
= incorrect argument set
4.
=sumif(amount approved:amount approved,[pipeline status]:[pipeline status], "approved")
=unparseable
Can someone please help? I am starting to lose it and on a deadline.
Thank you!
