Hello,
I'm having trouble coming up with a formula.
I wish to add #s in Column C if cells from Column A:
Monday-Thursday and their corresponding amounts in Column B are =>500
Friday and their corresponding amounts in Column B are =>1200
Saturday and their corresponding amounts in Column B are =>2000
Sunday and their corresponding amounts in Column B are =>600
If each day's criteria are not met, I wish for a BLANK value return.
A B C
1 Thursday 400 5
2 Friday 1300 6
3 Saturday 2000 2
4 Sunday 500 8
5 Monday 450 4
6 Tuesday 500 5
7 Wednesday 600 8
8 Thursday 550 3
9 Friday 1100 2
10 Saturday 2100 9
11 Sunday 700 7
12 Monday 300 8
13 Tuesday 500 4
14 Wednesday 400 4
Any help is greatly appreciated!
Thank you,
WoWo
Bookmarks