Posted to microsoft.public.excel.worksheet.functions

Max of Newnan Max of Newnan is offline

external usenet poster

Posts: 1

Trying to enter a formula to sum a colum based on 2 condition

This is the formula IF C2:C60 = C76 AND IF D2:D60 = L75 SUM(A2:A60).
How would this be entered

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
Formula based on condition	claude jerry	Excel Discussion (Misc queries)	6	November 27th 08 01:14 PM
Condition format a row based on a formula	Tysmema	Excel Worksheet Functions	2	May 2nd 08 02:22 PM
Condition format a row based on a formula	Tysmema	Excel Worksheet Functions	1	May 2nd 08 02:20 PM
Formula for Inputing a Value based on a Condition	la90292	Excel Worksheet Functions	3	September 10th 07 05:12 AM
formula to calculate a column based on dates in a different colum.	Pam	Excel Worksheet Functions	1	April 7th 05 07:59 PM

All times are GMT +1. The time now is 02:44 AM.

About Us

"It's about Microsoft Excel"