"I'm missing a piece of the puzzle here and I can't get the formula to work.
I have sales opportunity data and I'm trying to get it to add up the dollar amounts if column A equals "BB sales cycle" and Column B equals "A". It's not working and I'm getting a NUM error. Here's a sample of the data...
COLUMN A COLUMN B COLUMN C
BB Sales Cycle A $105,000
BB Sales Cycle B $100,000
MM Sales Cycle B $98,000
BB Sales Cycle A $100,000
The result should be $205,000. Can anyone help with the formula? Sorry I can't get the question to show in columns of any kind - the data is smooshed.
2006-11-06
05:17:50
·
3 answers
·
asked by
Stella Bing
3