| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif formula doesn't add up
What am I missing?
I have this formula in C28: =SUMIF($H:$H,$H27,C:C) c12.value = 308 c13.value = 243 c14.value = 234 c15.value =275 I'm getting 1126 in c28 instead of 1060 The total should be 1060. I do run a macro but it removes the totals and adds them back in. The formula should work. The other columns total up. What exactly is the sumif doing? tia, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiply formula where 1 cell has a (sumif) formula as a result | Excel Worksheet Functions | |||
| sumif formula | Excel Worksheet Functions | |||
| Sumif and And formula | Excel Discussion (Misc queries) | |||
| Formula using SUMIF & IF | Excel Worksheet Functions | |||
| Is there a MAXIF formula similar to the SUMIF formula? | Excel Discussion (Misc queries) | |||
Threaded Mode
