| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
SUMIF excel function not working
I am using this formula and it is returning a zero for the sum amount,
however, the function command tells me that it should return a 4 (which is correct). SUM(IF((A2:A3352="Bee, Lucas W.")*(G2:G3352="60"),F2:F3352)) What am I doing wrong? |
|
#2
|
|||
|
|||
|
If Column G contains numerical values, remove the quotes from its
criterion... =SUM(IF((A2:A3352="Bee, Lucas W.")*(G2:G3352=60),F2:F3352)) ....confirmed with CONTROL+SHIFT+ENTER. Hope this helps! In article , "AMXAH" wrote: I am using this formula and it is returning a zero for the sum amount, however, the function command tells me that it should return a 4 (which is correct). SUM(IF((A2:A3352="Bee, Lucas W.")*(G2:G3352="60"),F2:F3352)) What am I doing wrong? |
|
#3
|
|||
|
|||
|
Worked great, Thank You.
"Domenic" wrote: If Column G contains numerical values, remove the quotes from its criterion... =SUM(IF((A2:A3352="Bee, Lucas W.")*(G2:G3352=60),F2:F3352)) ....confirmed with CONTROL+SHIFT+ENTER. Hope this helps! In article , "AMXAH" wrote: I am using this formula and it is returning a zero for the sum amount, however, the function command tells me that it should return a 4 (which is correct). SUM(IF((A2:A3352="Bee, Lucas W.")*(G2:G3352="60"),F2:F3352)) What am I doing wrong? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| linear interpolation function in excel | Excel Worksheet Functions | |||
| @ and "function not valid" error (Excel 2003) | New Users to Excel | |||
| Function Keys in Excel | Excel Discussion (Misc queries) | |||
| Access Module coded converted to Excel Function | Excel Discussion (Misc queries) | |||
| I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Linear Mode
