Question about Microsoft Office Computers & Internet
show the sum of the cells that matches with a given output suppose i have an amount that may be the sum of different cells in a column .I want to find out which cells sum up to the amount given If the
FORMULA PROBLEM IN MS EXCEL WHEN I SUM THE CELLS VELUE THEN IT SHOW ME 0(zero) BUT IT'S TOTAL IS NOT 0(zero) The cells you are trying to sum are probably text and not numeric values. Format them as ...
Question about Microsoft Office Computers & Internet
...519=IF(HLOOKUP($D$4,$B5:$C5,1,TRUE)=$D$4,"X",1)1 6217=IF(HLOOKUP($D$4,$B6:$C6,1,TRUE)=$D$4,"X",SUM($D5,1))X 7311=IF(HLOOKUP($D$4,$B7:$C7,1,TRUE)=$D$4,"X",SUM($D6,1))#N/A
...me a final numerical amount. The unsuccessful equation I am using right now says =IF(F14="toilet",SUM(F16*0.3)) what I want is to be able to type any kinds of words into F14 and only if I type the ...
...grand total columns one running vertically and one horizantally and is there a way to automate the sum of those new columns If Access is anything like Excel, you can put in one of the cells: ...
1 plus 1 is equals to 11? Try using the formula sum(1;1) Thats due to some configuration issues, Cheers
Question about Microsoft Office Computers & Internet
sum cells that the fonts have diffrent colors I have a spreadsheet that has cells wich have diffrent font colors. I want to add only the cells that have a blue font and not black or red fonts. I think
Question about Microsoft Office Computers & Internet
...and not the output I have 3 different tabs with 3 different values. IN the 4th tab Im trying to sum them up by using =tab1cel1+tab2cel2 and when I press enter it gives me the formula not the ...
Question about Microsoft Office Computers & Internet
...a new column in ms word 2003 I just need to know how to be able to click into a cell for a formula sum and have it to stay in that
Question about Microsoft Office Computers & Internet
...is a bit trickier but still easy to do. Click on cell J131 Then click on the black arrow on the Autosum button, it looks like this: and select sum. This will put a dotted-line box around the data ...
944 questions posted
Usually answered in minutes!
7,277 Questions
239 Questions
265 Questions
207 Questions