Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing across columns while skipping some columns
Does anyone know of an easy way to accomplish this?
In the example below, I do not wish to add the values in columns G18 and J18. =SUMIF(F18:L18,"<#N/A",F18:L18) Thanks in advance for any replies. Joe |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing across columns while skipping some columns
How about
=SUMIF(F18:L18,"<#N/A")-SUMIF(G18,"<#N/A")-SUMIF(J18,"<#N/A") Note the third argument is not needed since you are summing the same range as you are testing. best wishes -- Bernard Liengme Microsoft Excel MVP people.stfx.ca/bliengme email address: remove uppercase characters "JAG" wrote in message ... Does anyone know of an easy way to accomplish this? In the example below, I do not wish to add the values in columns G18 and J18. =SUMIF(F18:L18,"<#N/A",F18:L18) Thanks in advance for any replies. Joe |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing across columns while skipping some columns
Hi,
Try this =sumif(F18:L18,"=0")+sumif(F18:L18,"<=0") -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "JAG" wrote in message ... Does anyone know of an easy way to accomplish this? In the example below, I do not wish to add the values in columns G18 and J18. =SUMIF(F18:L18,"<#N/A",F18:L18) Thanks in advance for any replies. Joe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum skipping columns | Excel Discussion (Misc queries) | |||
Totals skipping columns | Excel Discussion (Misc queries) | |||
Lookup function skipping columns | Excel Worksheet Functions | |||
skipping columns part 2 | Excel Worksheet Functions | |||
skipping columns | Excel Worksheet Functions |