Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
BMWPRO
 
Posts: n/a
Default how do you do a sumif function on more than one worksheet?

My question is this. I record sales data on seperate sheets depending on month.
I want use sumif function on all sheets but it returns a #value error. The
function works if it is one one sheet but has a problem when I add another
sheet. The function is used to find a salespersons name and how many sales
they have over a 12 month period. Please Help!!!!
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
some more detail:
- how are your sheets named
- what formula are you using
- which columns store your data and your values

--
Regards
Frank Kabel
Frankfurt, Germany

"BMWPRO" schrieb im Newsbeitrag
...
My question is this. I record sales data on seperate sheets depending

on month.
I want use sumif function on all sheets but it returns a #value

error. The
function works if it is one one sheet but has a problem when I add

another
sheet. The function is used to find a salespersons name and how many

sales
they have over a 12 month period. Please Help!!!!


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
Incorrect result using NPER worksheet function KG Old Wolf Excel Worksheet Functions 7 November 3rd 08 02:49 AM
SUMIF Function Peter Curtis Excel Discussion (Misc queries) 2 January 12th 05 02:02 PM
using logical functions as criteria with the SUMIF function pfdubz Excel Worksheet Functions 6 December 1st 04 07:40 PM
left worksheet function within a combo box Billing Goddess Excel Worksheet Functions 3 November 15th 04 08:58 PM
Can I use a cell reference in the criteria for the sumif function. Number Cruncher Excel Worksheet Functions 2 November 4th 04 07:52 PM


All times are GMT +1. The time now is 04:01 AM.

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

About Us

"It's about Microsoft Excel"