If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sumproduct formula help (possible Index????)
Morning all
I am stuck with a forumula that I hope someone will be able to help with. It's quite long winded the way I am doing it but am hoping that it may be able to be shortened. Column B Lines 42 - 58 has either "current" or "ex" in the cells Column G lines 42 - 58 has a date in them Column H lines 42 - 58 has either 1, 2, or 3 in them. The line 3 (columns I AR have months of the year in them) I need something in 1 formula that says 1. IF B42="Current" and G42=I3 TAKE H42 otherwise 0 2. IF B42="EX" and G42=I3 TAKE H42 *.7 otherwise 0 I was using a sumproduct formula but to run the same forumulas 16 times (lines 42 - 58) seems too long, I was wondering if there was a way of shortening it. Many thanks for any help If |
Thread Tools | |
Display Modes | |
|
|