Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 7
Default multiply formula where 1 cell has a (sumif) formula as a result

trying to do a simple multiplication formula for cells and then copy formula
for the rest of the cells.
The first cell (b5) has a formula. It is a sumif formula. the result is a
"special" under format cell. That formula result is, in this example, is a
16. The second cell (c5) is just a number 20. When i do the basic multiply
formula =(b5*c5) I get 320 as the result. Everything OK so far! When I
select the 320 cell, edit, copy.....then try to paste that formula to the
rest of the cells, I get the 320 in each cell. Column B, where the sumif
formula resides, is my problem I think. Column B is an ARRAY.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default multiply formula where 1 cell has a (sumif) formula as a result

Have you checked Tools/ Options/ Calculation, to make sure it's set to
Automatic?
--
David Biddulph

"kcip" wrote in message
...
trying to do a simple multiplication formula for cells and then copy
formula
for the rest of the cells.
The first cell (b5) has a formula. It is a sumif formula. the result is
a
"special" under format cell. That formula result is, in this example, is
a
16. The second cell (c5) is just a number 20. When i do the basic
multiply
formula =(b5*c5) I get 320 as the result. Everything OK so far! When I
select the 320 cell, edit, copy.....then try to paste that formula to the
rest of the cells, I get the 320 in each cell. Column B, where the sumif
formula resides, is my problem I think. Column B is an ARRAY.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
formula for multiply one cell to one of two other cells? M.Rafat Excel Discussion (Misc queries) 6 April 13th 07 07:02 AM
Sumif formula not giving result abanerji Excel Discussion (Misc queries) 5 June 13th 06 07:20 PM
formula cell value multiply by percentage formula using percentage question Excel Worksheet Functions 3 June 2nd 06 02:18 AM
Advanced formula - Return result & Show Cell Reference of result Irv Excel Worksheet Functions 7 May 6th 06 03:36 AM
Cell doesn't show formula result - it shows formula (CTRL + ' doe. o0o0o0o Excel Worksheet Functions 6 November 19th 04 04:13 PM


All times are GMT +1. The time now is 01:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"