Posted to microsoft.public.excel.worksheet.functions

CiaraG

Posts: n/a

SUMIF Formuale with 2 variables

Good morning all,

I am using the following array formuale in my worksheet to calculate the sum
of a column where one column is equal to a variable and another column is
equal to "CN". My formulae keeps giving me the NUM error. This error
appears even when I use the SUMPRODUCT function. Has anyone any ideas on how
to amend this???

{=SUM(IF((EmployeeData!A:A=B8)*(EmployeeData!L:L=" CN"),EmployeeData!K:K))}

Thanks,

Ciara

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
How to use SUMIF to return sums between two values located in cells	ScottBerger	Excel Worksheet Functions	2	April 23rd 23 09:05 PM
VBA reseting variables	bpeltzer	Excel Discussion (Misc queries)	0	February 4th 06 03:52 PM
How do I set up a nested SUMIF formula for a number of variables?	Nancy	Excel Worksheet Functions	2	January 5th 06 05:57 PM
SUMIF variables	Steve	Excel Discussion (Misc queries)	2	February 18th 05 01:32 PM
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function	Oscar	Excel Worksheet Functions	2	January 11th 05 11:01 PM

All times are GMT +1. The time now is 09:34 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us