Sumif

[nishad]

Hai good day all,
I have a problem while using sum if with multiple condition in same column, my data as given

January 125000
Frbruary 75000
March 50000
April 40000

When im trying to get the total amount of january and february using sumif its not working , please help me on this

Thnks
Nishad

 

[NARAYANK991]

Hi ,

Try this :

=SUM(SUMIF(A2:A10,{"January","February"},B2:B10))

Narayan

 

[Gangadhar Yeligaty]

=SUM(SUMIF($A$2:$A$5,{"January","Frbruary"},$B$2:$B$5))

 

[nishad]

Hai good day all , please inform me a solution tht i present as given

I have a data look like this
Name month amount
A. April. 200
B. April. 200
C. April. 200
D. April. 200
A. May. 300
B. May. 300
C. May. 300
D. May 300
A. June. 450
B. June. 450
C. June. 450
D. June. 450

I want to present my data as

Name april. May. June
A
B
C
D

Intried v look up with choose but it showing some error please help me.on this

Thanks and regards....
Nishad Mohammed

 

[rahulshewale1]

hii ,

please find the attached formula base solution.i hope it will help you.

=SUMPRODUCT(SUMIFS($C$2:$C$13,$B$2:$B$13,$F$2:$F$4,$A$2:$A$13,A18))



Thanks
Rahul shewale

 

[nishad]

Hai thnks
its working ., also let me know if its possible to do with v look up function

 

[Khalid NGO]

also let me know if its possible to do with v look up function

Hi nishad,

VLOOKUP will not work the way you want.

You can use the Pivot Table

Regards,

 

[rahulshewale1]

hii nishad,

you can do fast and easiest way with pivot table.please see attached sheet.
Select data--go to insert option---selcet pivot table-drag name and month to rows ---qty drag to value --

-if tabular form -click on pivot table go to design ---report layout---select show in tabular form


Thanks
Rahul

 

[AVK]

Hello nishad, plz see attach file.
Secondly, sumif faster than sumproduct formula. sumif or sumifs calculating on ranges, whereas SUMPRODUCT calculating on arrays.