how conditions allowed in IF statement

[roofi]

Dear Freinds
I have 12 conditions to get result. immediate aid will be appreciated.

roofi

[Sam Capricci]

sometimes you can use a lookup statement to get results which will reduce the number of IF statements needed. Sometimes a reference table and a vlookup will also work. Without more specifics it is impossible to give you better advice.

[roofi]

please see file

[roofi]

please see attached file

[Fotis1991]

Perhaps

=INDEX($C$2:$N$2,MATCH(TEXT(MONTH(TODAY()),"mmm"),$C$1:$N$1,0))

[roofi]

Hi Fotis
thats great!
your suggestion encouraged me to extend my question please review my new sheet now.

regards
roofi

[Fotis1991]

I am not able to see anything new to your sheet. What's the new question?

[roofi]

If Month is = D9
what will be the formulae

[Fotis1991]

Do i miss something? D9 has no value. It's an empty cell!!

[roofi]

sorry for inconvenience
please see now

[Fotis1991]

=index($c$2:$n$2,match(d9,$c$1:$n$1,0))

[roofi]

Great it solved the issue
thanx


Dear Fotis
one more question
same situation if condition of the same is true i need total from Jul to current month
for example
if D9 = Aug

i need total from Jul to Aug

please

[Fotis1991]

Using a helper & hidden row.

=IF(C2=$D$10m1mIF(D1=1m1m""))

Then

=SUMIF(C1:N2,1,C3:N3)

[roofi]

dear Fotis
Thats nice!
its working well as desired.
one more question please
please see attached sheet again
regards
roofi