Posted to microsoft.public.excel.worksheet.functions

Lisa

external usenet poster

Posts: 328

sumif formula to calculate value of cell if certain criteria are m

i am working on a time sheet speadsheet. Cells B14 to H15 are the hours per
day worked. The formula I am trying to figure out is

if the sum of b14 to h14 44 then enter the value 44, if the sum is less the
44 then enter the sum of the cells.
--
newbie at large!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Criteria Syntax in SUMIF formula	RollieG	Excel Discussion (Misc queries)	4	October 29th 08 04:42 PM
Calculate a SUMIF if criteria is between 2 date ranges	Anthony P	Excel Worksheet Functions	4	October 13th 06 05:12 PM
SUMIF Formula w/ OR Criteria	SJT	Excel Discussion (Misc queries)	5	August 4th 06 05:00 PM
Sumif with 2 cell criteria	Cube Farmer	Charts and Charting in Excel	1	January 27th 06 09:40 AM
Can a formula be used in the Criteria field of SUMIF??	peter	Excel Worksheet Functions	1	October 15th 05 12:14 PM

All times are GMT +1. The time now is 10:12 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us